Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help on this scenario in higher priority.
This my straight table
My requirement: i want separate the positive negative zero and no data for suppose negative values like below
=if([sep]-[apr]<0,[sep]-[apr]) i used this expression so below output wiil come.
I want see only negative values in based on expression(difference) that mean delete or hide reaming data.
i want see only 4 negative values(-0.18,-1.18,-1.00,-2.67) reaming data (spaces) i don't want see that mean hide or delete those rows.
Hi,
add this in calculation dimension
=if(
(aggr(sum({$<Month={'September'}>}[Passing Fraction])/Count({$<Month={'September'}>}[Passing Fraction]),[Attribute Name]))
>
(aggr(sum({$<Month={'April'}>}[Passing Fraction])/Count({$<Month={'April'}>}[Passing Fraction]),[Attribute Name])),1,null())
and check option "suppress when value is null" .
Thanks,
Anjee
Add the same condition to the other expressions: =if([sep]-[apr]<0, ...apr expression... )
In Calculated Dimension Maybe
if([sep]-[apr]<0, YourDimension)
Hi,
add this in calculation dimension
=if(
(aggr(sum({$<Month={'September'}>}[Passing Fraction])/Count({$<Month={'September'}>}[Passing Fraction]),[Attribute Name]))
>
(aggr(sum({$<Month={'April'}>}[Passing Fraction])/Count({$<Month={'April'}>}[Passing Fraction]),[Attribute Name])),1,null())
and check option "suppress when value is null" .
Thanks,
Anjee
It's working finally...Thanks to every one
Thanks man..its working
Thanks...its working