Hi, I want to subtract two fields - Bill amount less Item Receipt. Then use the formula in the Criteria > Summary. I have done the following but no joy. CASE WHEN {applyingtransaction.accounttype} = 'Other Current Asset' AND {applyingtransaction.fxamount} - CASE WHEN {applyingtransaction.accounttype} = 'Other Current Liability' AND {applyingtransaction.fxamount} = 0 THEN 1 ELSE 0 END Do you know why it does not work?

you have 2 case statements, one of which is incomplete

There's a subtraction sign between the two case statements.

has no effect what so ever on your incomplete case statement

Your statement doesn't explain what's missing.

start at the searched case statement

Not entirely sure what your formula is trying to do as the minus sign is a little ambiguous. It's probably either

CASE WHEN ... - CASE WHEN ... THEN ... ELSE ... END ...
THEN ...
ELSE ...
END

OR

CASE WHEN ... THEN ... ELSE ... END
-
CASE WHEN ... THEN ... ELSE ... END

That's what Netsuite expects, anyway. What you have right now is

CASE WHEN ...
-
CASE WHEN ... THEN ... ELSE ... END

So your first CASE statement is incomplete (it's missing the THEN and the END.

Thanks @battk and @Jon Kears for your inputs. I have two cases as follows: CASE WHEN {applyingtransaction.accounttype} = 'Other Current Asset' THEN {applyingtransaction.fxamount} ELSE - CASE WHEN {applyingtransaction.accounttype} = 'Other Current Liability' THEN ABS({applyingtransaction.fxamount}) END END They work as expected. However I want to use both expressions in Criteria to remove some lines. The objective is if the amount for expression 1 minus expression 2 equals zero, then I don't want to see them, otherwise display. That's the bit I'm struggling to get.

you want to think in terms of grouping rows