Help in Expression

Pujitha — Tue, 10 Aug 2021 03:46:20 GMT

Hello Everyone,

I have bar chart with 4 expressions and one Drill down Dimension(Country-State-Account). I have field called 'Status '.Expressions I gave

sum((if([Status]='Open',1,0))) - for Open Account

'Percentage Open='&Num((sum((if([Status]='Active',1,0)))/(Count([Account]))),'#,##0.0%')

=sum((if([Case Status]='Closed',1,0)))- For Closed Account

'Percentage Closed='&Num((sum((if(Status]='Closed',1,0)))/(Count([Account]))),'#,##0.0%')

Though I gave these 4 expressions in bar chart when I drill down to Account level - it is showing canceled Accounts too..

My requirement is - it should not involve canceled accounts. How to modify the formula to achieve this. Please help me asap. Thank you!

Re: Help in Expression

jjbom1990 — Tue, 10 Aug 2021 06:43:50 GMT

Please have a look into set analysis.

example to count or sum facts based on a preselected deminsion.

=sum({<Status = {'Open'}>}<amount>)

where <amount> is the field you want to sum. you of course also could use a count.