This content has been marked as final. Show 8 replies
Below is my condition for the Net cal:
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.
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???