Nominal Value in Consolidation

[kenship]

I'm using rule with Roundp function to limit cell values to 2 decimal places for rules and TI.

However, I still result in (0.00) which doesn't allow suppress 0 to work.

Using a real example I have A, B, C rolled up to D,

A is 79.98
B is (4,621.26)
C is 4,541.28

However in TM1 D is calculated as -9.09494701772928E-13 as I snapshot to Excel.

I wonder if there is any way that I can eliminate these nominal value.

Kenneth

[tiagoblauth79]

I don't know if this is the most "elegant" solution, but you can put a clause:

• ['Result'] =N: IF(Roundp(['A'] - ['B'], 2) = 0, Continue, Roundp(['A'] - ['B'], 2));

[gtonkin]

You could try looking at MagnitudeDifferenceToBeZero (although may only apply to division)
Similar issue here - Macsir still hoping someone has success and can confirm that this resolves these kinds of issues.

[tomok]

AFAIK, even if a consolidation nets to zero it will not zero suppress if any of it's children have a non-zero value, just like your example.

[gtonkin]

AFAIK, even if a consolidation nets to zero it will not zero suppress if any of it's children have a non-zero value, just like your example.

I used to think the same but had a recent situation where I have a C level with 6 N levels as children with values like 1, -1, 2, -1, -1, 0. This nets to zero but when zero suppressed, and only showing the C levels on rows for example, I get the "No values available" dialogue - this is on 10.2.2 FP4 btw.

[kenship]

Thanks all for the reply. I use a rule to force rounding on the consolidated element and it works for me.