ERR in cells

Post Reply
bunchukokoy
Regular Participant
Posts: 197
Joined: Thu Dec 03, 2009 8:47 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2.x
Excel Version: 2010
Location: Singapore

ERR in cells

Post by bunchukokoy »

Hi guys,

Has anyone encountered this one? I don't see anything wrong with the rules, but it returns ERR in the cells.
The issue seems to be in the right part of &.
I tried DB, tried ATTRS. Didn't work.

Thanks in advance.
Capture.PNG
Capture.PNG (18.51 KiB) Viewed 1831 times
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: ERR in cells

Post by Wim Gielis »

What happens if you:
- do a Trace calculation on any of the cells ?
- limit to 1 condition to test, instead of having 2 conditions ?
- hardcode certain functions / references ?
- swap places for !}Groups and ATTRS( ... ) (switch left hand side and right and side of the equation) ?
Best regards,

Wim Gielis

IBM Champion 2024
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
bunchukokoy
Regular Participant
Posts: 197
Joined: Thu Dec 03, 2009 8:47 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2.x
Excel Version: 2010
Location: Singapore

Re: ERR in cells

Post by bunchukokoy »

Hi Wim,

Sorry I didn't get back. Yeap, nested if solved it. Thanks.
Post Reply