Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ])))
Hi,
Can you try something like this
=Sum({<[ID]={'*'}>}Total [Annual Expense ])
Or
=Sum({<[ID]= {"=len(trim([ID])) >=1"}>} Total [Annual Expense ])
Try like:
sum(Total{<[ID]={"=Len(ID)>0"}>} [Annual Expense ])
Awesome.Thanks much.