Set Analysis

[BI_Dev]

I want o get the total Expense only if the length of ID is >0 and I ma using the below expression and it is not working.

Any help is appreciated. Thank you.

sum(Total(({<[ID]=>} [Annual Expense ])))

[mdmukramali]

Hi,

Can you try something like this

=Sum({<[ID]={'*'}>}Total [Annual Expense ])

Or

=Sum({<[ID]= {"=len(trim([ID])) >=1"}>} Total [Annual Expense ])

[tresesco · Accepted solution]

Try like:

sum(Total{<[ID]={"=Len(ID)>0"}>} [Annual Expense ])

[BI_Dev]

Awesome.Thanks much.