Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI!
If I need not to show a particular records in a table, what could be the expression to be used.As per the chart given below, when ever ACT<BUD, such records to be restricted from showing in the table. I expect your ideas towards this by using where clause as well as using an expression! As per the chart, Staff Welfare expense under EM, & RA are to be excluded since they are nt having a negative variance.
Thanks In Advance
Neville.
Hello!
You should use calculated dimension with this condition:
if(aggr(sum(BUD)-sum(ACT),BR_CODE,TYPE,CATEGORY)>0,Null(),BR_CODE)
and check "Suppress When Value Is Null" on Dimensions tab
If you find this solution useful - please mark answer as correct or helpful and close the topic. Thank you!
Please respond!
Regds
Neville
Hello!
You should use calculated dimension with this condition:
if(aggr(sum(BUD)-sum(ACT),BR_CODE,TYPE,CATEGORY)>0,Null(),BR_CODE)
and check "Suppress When Value Is Null" on Dimensions tab
If you find this solution useful - please mark answer as correct or helpful and close the topic. Thank you!