Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
  • 1.  rules at C level consolitions

    Posted Fri July 19, 2024 08:38 AM

    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?



    ------------------------------
    Venkata Nori
    ------------------------------


  • 2.  RE: rules at C level consolitions

    Posted Fri July 19, 2024 08:59 AM

    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



    ------------------------------
    Edward Stuart
    ------------------------------



  • 3.  RE: rules at C level consolitions

    Posted Fri July 19, 2024 10:34 AM
    Edited by Venkata Nori Sun July 21, 2024 11:36 AM

    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;



    ------------------------------
    Venkata Nori
    ------------------------------



  • 4.  RE: rules at C level consolitions

    Posted Sat July 20, 2024 05:07 PM

    Circular logic.



    ------------------------------
    John O'Leary
    ------------------------------