Dear all,
I have a chart and I'm facing problem with conditional sum sintax.
In particular I have an expression that says
Sum (BALANCE_CTV2)
Now I need that the expression sum only the values where the filed ACC_TYPE_DESCRIPTION is equal
At Bank
or
Cash Pooling
or
Restricted
or
Short Term Investment
As alternative it could be more easy to say to sum if it is not equal to one of this two values:
Committed
or
Credit Facilities Drawn
If i try this sintax with just one of the values it works
=SUM({<ACC_TYPE_DESCRIPTION ={'At Bank'}>}BALANCE_CTV2)
but when i try to add the other values with the OR operator it doesn't work
Could someone tell me how is the sintax to include or exclude more then one value?
Thank you
