Nominal Value in Consolidation

Post Reply
kenship
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

Nominal Value in Consolidation

Post by 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
User avatar
tiagoblauth79
Posts: 25
Joined: Fri Aug 26, 2016 1:42 pm
OLAP Product: Cognos BI and TM1
Version: 10.2.2
Excel Version: 10
Contact:

Re: Nominal Value in Consolidation

Post by 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));
Last edited by tiagoblauth79 on Fri Jul 28, 2017 1:12 pm, edited 1 time in total.
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Nominal Value in Consolidation

Post by 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
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Nominal Value in Consolidation

Post by 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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Nominal Value in Consolidation

Post by gtonkin »

tomok wrote: Thu Jul 27, 2017 12:35 pm 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
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

Re: Nominal Value in Consolidation

Post by kenship »

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