Skip to Content

Zero suppression not working with calculation having 'X'

May 30, 2017 at 11:26 AM


avatar image
Former Member

hi all

Using AfO 2.4, created a report that has 3 columns: this year sales, last year sales, and the difference between the 2 (report level calculation).

When both this year and last year sales are zero, the result of the calculation shows 'X'.

I would like to suppress all zero rows, and see that those rows where the calculation = 'X' don't get suppressed. If I remove the calculation altogether (ie only showing sales this year and last year), zero suppression works fine as expected.

Does anyone know if this behavior can somehow be changed? (i observed the same behavior using BEx Analyzer).

Many thanks for your input


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Anand Kumar May 31, 2017 at 08:29 AM


check by using NODIM functionality in calculation formula. Or add zero in calculation formula((Last year - this year) + 0 ).



Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you Anand.

I'm not sure how the NODIM would help, but did try the NDIV0 around my calculation, and this has solved my issue.

Thank you for providing me a hint in the right direction.