How to delete empty cell in straight table in expression tab

[ramrongala]

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.

[Gysbert_Wassenaar]

Add the same condition to the other expressions: =if([sep]-[apr]<0, ...apr expression... )

[rupamjyotidas]

In Calculated Dimension Maybe

if([sep]-[apr]<0, YourDimension)

[veeranj · Accepted solution]

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

[ramrongala]

It's working finally...Thanks to every one

[ramrongala]

Thanks man..its working

[ramrongala]

Thanks...its working