Skip to Content
avatar image
Former Member

Zero suppression not working with calculation having 'X'

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

Bart

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 31, 2017 at 08:29 AM

    Hi,

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

    Regards,

    Anand

    Add comment
    10|10000 characters needed 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.

      Regards

      Bart