0 Replies Latest reply on May 23, 2018 1:10 PM by 3460247

    Allocation Business rule

    3460247

      Hi All,

       

      AS per below requirement , developed Bussines rule

       

      FIX (@LEVMBRS("UIT9000", 0),@LEVMBRS("TWW9000", 0),"No_Type","S30000","USD","No_Client_Source",&SV_Optima_ActCrYr,{RTP_Optima_Scenario_Target},{RTP_Optima_Version_Target})

      /*{RTP_Optima_Period_Target} = (@SUMRANGE({RTP_Optima_Scenario_Source},@Xrange("Jan"->{RTP_Optima_Version_Source},{RTP_Optima_Period_Source}->{RTP_Optima_Version_Source}))- @SUMRANGE({RTP_Optima_Scenario_Target},@Xrange("Jan"->{RTP_Optima_Version_Target},{RTP_Optima_Period_Target}->{RTP_Optima_Version_Target}))) + ({RTP_Optima_Period_Target}->{RTP_Optima_Scenario_Target}->{RTP_Optima_Version_Target})
      */
      /*{RTP_Optima_Period_Target} = @SUMRANGE({RTP_Optima_Scenario_Source}->{RTP_Optima_Version_Source},"Jan":{RTP_Optima_Period_Source})-@SUMRANGE({RTP_Optima_Scenario_Target}->{RTP_Optima_Version_Target},"Jan":{RTP_Optima_Period_Source})+ {RTP_Optima_Period_Target}->{RTP_Optima_Scenario_Target}->{RTP_Optima_Version_Target};

      */

      {RTP_Optima_Period_Target} = @SUMRANGE({RTP_Optima_Scenario_Source1}->{RTP_Optima_Version_Source1},"Jan":{RTP_Optima_Period_Source})-@SUMRANGE({RTP_Optima_Scenario_Source2}->{RTP_Optima_Version_Source2},"Jan":{RTP_Optima_Period_Source})+ {RTP_Optima_Period_Target}->{RTP_Optima_Scenario_Target}->{RTP_Optima_Version_Target};

       

      ENDFIX

       

       

       

      For
      the above conditions when the rule is run ;

       

      Column
      N is the may month calculation that gets overwritten

      Column
      O is the May month existing value BEFORE it is overwritten.

      Column
      P is the True up calculation done manually

      Column
      R is the “Check” and it should show 0 always for the rule to be correct –
      formula used is  ‘column N – Column P’ – All defects highlighted in RED.

       

       

      R is the “Check” and it should show 0 always , How to write the code?

       

       

      Please help me .