Hi,
I'm experiencing an issue with a rule where I am getting a #NA in the rules tracer that leads me to believe I either have a circular reference or am dividingby zero.
When I trace the error I get the following error:
1-.#IND
Does anyone know what this means as I am using '\' for division and the calculation is not circular.
Thanks,
Dan
Rules Tracer Error
-
dan.kelleher
- Community Contributor
- Posts: 128
- Joined: Wed Oct 14, 2009 7:46 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 11
- Location: London
-
kpk
- MVP
- Posts: 214
- Joined: Tue Nov 11, 2008 11:57 pm
- OLAP Product: TM1, CX
- Version: TM1 7x 8x 9x 10x CX 9.5 10.1
- Excel Version: XP 2003 2007 2010
- Location: Hungary
Re: Rules Tracer Error
Tip1:
You have to check your feeders from circular reference point of view.
The following scenario could cause this kind of issue:
C=A*B
C=>A
A=>C
Tip2:
You have chain type rule (over the time dimension) and you have not handled (eg STET) the first element of the chain.
You have to check your feeders from circular reference point of view.
The following scenario could cause this kind of issue:
C=A*B
C=>A
A=>C
Tip2:
You have chain type rule (over the time dimension) and you have not handled (eg STET) the first element of the chain.
Best Regards,
Peter
Peter