0 Replies Latest reply on May 23, 2018 5:55 AM by 3460247

    Bussiness Rule issue

    3460247

      FIX (@Relative("UIT9000",0),@Relative("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_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

       

       

      AS per My Requirement is below :

       

      Column N is “May” month for which true up has been done

      Source 1 è Actual , Final

      Source 2 è 2018-Mar_RF and Final

      Target è Current Forecast and Current

      Source period YTD è “Apr”

       

      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.

       

      As the above requirement , How to write the code ? please help.