Hi,
I have a rule that applies to both N and C levels. There are instances where the value of Consolidation might be zero, but the N level might have values. The issue is when zero suppression is on while only looking at C level zero values are not suppressed.
I'm not sure what you are expecting here. The highlighted cell is not going to suppress from a column perspective because there are values for other rows in the same column and it's not going to suppress from a row perspective because there are values for other columns in the same row. That's how zero suppression works in TM1. Were you expecting something else?
Hello Tomok,
I was showing it expanded for clarity.
When the Period dimension is collapsed to only show Consolidation. It is not suppressing the exception column.
Trace Calculation shows 0.
I tested it out by slicing it to excel and divided a value by the exception to prove it to myself that it is indeed a zero as I got #DIV/0!
You still see the 0 on the consolidation element because you try to override a consolidation with rules. The zero-suppression will not make that intersection disappear because if there was no rules on C: level, the value would not be 0. I guess that's how TM1 works !