How to remove AR Table display those amount which is 0.00 ?

[admin11]

Hi All

I have below expression working fine :-

AR_AMT_ = if(sum(AR[A/R amount include GST in LC]) =0 , blank(),sum(AR[A/R amount include GST in LC]))

But it display 0.00 amount , in actual fact the amount is zero , it should not appear on the table . 

Can some one share with me how to remove them ?

Paul

[admin11]

Hi All

https://www.dropbox.com/s/t2ovd0bzjss9jbr/PBT_V2021_127%20how%20to%20remove%20AR%20table%200%20amoun...

Above is my PBI file

Paul

[PaulDBrown]

@admin11 

The problem is that the sum calculation looks for rows with values = 0. You have rows for the same company which have -ve and +ve values (whose final sum is 0). These rows are not = 0, therefore they are included.

To remove these:

Create a measure for the sum of values:

SumAr = SUM(AR[A/R amount include GST in LC])

Now use this final measure in the visual:

SumAR (no 0 values) = IF(SUMX(Company, [SumAr]) >0, [SumAr])

[themistoklis · Accepted solution]

@admin11 

Please change the formula to this one and it will bring the results you want.

AR_AMT_ = if(ROUND(sum(AR[A/R amount include GST in LC]),0)=0, blank(),sum(AR[A/R amount include GST in LC]))

I have added the ROUND function. It seems that thenumber has multiple decimal places and is slightly above zero. (e.g. 0.000001)

[admin11]

Hi Themis

Thank you so much for sharing the expression work fine,

Paul