Error

Post Reply
Jorge Rachid
Posts: 113
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Error

Post by Jorge Rachid »

Hi everyone,

I am facing an error on summation as screenshot attached.

Does anyone knows what can be happening?

Thanks a lot,

JR
Attachments
Error.jpg
Error.jpg (98.74 KiB) Viewed 3790 times
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Error

Post by Wim Gielis »

Do you have a calculation rule at C level ?
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Jorge Rachid
Posts: 113
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Re: Error

Post by Jorge Rachid »

No, only at N Level.

I do not understand because all n levels are calculated and they have value.
User avatar
gtonkin
MVP
Posts: 1265
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: Error

Post by gtonkin »

Please post what you can of the rule so that we can see if your rule is calculating N:, C: or all levels.
BR, George.

Learn something new: MDX Views
Jorge Rachid
Posts: 113
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Re: Error

Post by Jorge Rachid »

The problem is on the rule.

First I have a specific calculation for a field and then the general rule. For some reason when I try to do the specific rule first I get the #N/A. I have changed this metric for another one and it worked, I just don't understand why the specific generate this problem.

Does anyone have an idea?
Edward Stuart
Community Contributor
Posts: 248
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: Error

Post by Edward Stuart »

Switch your forward/ backward slashes
Post Reply