Planning Analytics

Hello team..I am facing an issue where my rule at C level consolidations is showing #NA..is there any reason why I would face this issue quite often?

Without seeing your code it can be difficult to diagnose but it is possibly due to the arithmetic operator in your rule statements:

https://www.ibm.com/docs/en/cognos-tm1/10.2.2?topic=formulas-arithmetic-operators#ArithmeticOperators_N702A0

Forward Slash: Division - returns an undefined value and displays N/A in the view when you divide by zero

Backward slash: Zero Display Division - same as Division operator, but returns zero when you divide by zero

Let us know if this resolves the issue and if not then please submit an example so we can review

Thank you for the response Stuart!

here is the rule I am using where I am trying to add a 1 to every consolidation.attaching the screenshot too

['Account_Emp':'TI Alloc Participant']=C:['Account_Emp':'TI Alloc Participant']+1;