on 05-30-2017 12:26 PM
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
Hi,
check by using NODIM functionality in calculation formula. Or add zero in calculation formula((Last year - this year) + 0 ).
Regards,
Anand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.