Saved search invalid expression error

We need to start by knowing more about the search, is this a Group results search?

I would start by Cleaning up your Case statement  it would like this

SUM ( case when {Yourfield}in( ‘Interest Earned’ ,‘Other Income’, ‘Revenue’ …) then {balance} end )-(Case when [Yourfield}=’Fixed Asset’ then (-{balance}) end )

You might need to wrap the balance in a NVL it would look like this:  NVL({balance},0)

I did not test this formula but it should work if you are not grouping the results..

The formula has error because you used multiple ‘CASE’ and yet used only one ‘END’.

If I read the operands, you try to do the ff:

• Expenses + Interest Expense + Adjustments + Depreciation + Revenue + Other Income + (Interest Earned – Fixed Asset)

Which is also similar to:

• Expenses + Interest Expense + Adjustments + Depreciation + Revenue + Other Income + Interest Earned – Fixed Asset

I also see that you are using 1 field ‘custrecord1’.

You can do the following in results:

• Formula (Numeric)
• Sum
• Formula:
  CASE WHEN {custrecord1} IN (‘Expenses’, ‘Interest Expense’, ‘Adjustments’, ‘Depreciation’, ‘Revenue’, ‘Other Income’, ‘Interest Earned’) THEN NVL({balance},0) WHEN {custrecord1} IN (‘Fixed Asset’) THEN NVL({balance},0)*-1 ELSE 0 END

While the formula might work, I suggest do not ‘hardcode’ your formula to these names. You can make the list source of {custrecord1} as custom record, say “Account Type”, then create field (for example, dropdown field named ‘Balance Type’ with this selection ‘Positive Balance’, ‘Negate Balance’, ‘Zero’). Then you can shorten your formula to:

• CASE WHEN {custrecord1.balancetype} = ‘Positive Balance’ THEN NVL({balance},0) WHEN {custrecord1.balancetype} = ‘Negate Balance’ THEN NVL({balance},0)*-1 ELSE 0 END

So if I add ‘Account Type Line’, let’s say ‘Other Expense’, I just need to set it up as ‘Positive Balance’, then automatically it is included in the result since formula is not hardcoded to account type names.