Hi everyone,
I am facing an error on summation as screenshot attached.
Does anyone knows what can be happening?
Thanks a lot,
JR
Error
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Error
- Attachments
-
- Error.jpg (98.74 KiB) Viewed 3789 times
-
- 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
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
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
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: Error
No, only at N Level.
I do not understand because all n levels are calculated and they have value.
I do not understand because all n levels are calculated and they have value.
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: Error
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?
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?
-
- 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
Switch your forward/ backward slashes