8 Replies Latest reply: Jul 7, 2015 2:08 AM by Amit Saini RSS

    Net Calulation Help

    Amit Saini

      Hi Folks,

       

      Below is my condition for the Net cal:

       

       

      Formula:

      If MSEG-SHKZG = H, MSEG-DMBTR is negative (i.e. MSEG-DMBTR is 9.207,87 the value to calculate with is –9.207,87)

      If MSEG-SHKZG = S, MSEG-DMBTR is positive

       

      Get for each entry selected MSEG-DMBTR and convert to either negative or positive value.

      Calculate the converted values to a net total.

       

      1. I.e. -100 + 50 = -50

       

      I'm trying for something like below for the Calculation :

       

      if(Debit_Credit_Indicator='H',- sum(Amt_Local_Curr), if(Debit_Credit_Indicator='S',sum(Amt_Local_Curr)))

       

      Any suggestions to calculate in the best way???

       

      Thanks,

      AS