How to subtract the two results fields to give a new total

[Former Member]

hi All,

Can any one help me how to subtract the two result fields  values to give new total

Eg:  Column A     Column B     Column B

       10                    15

       20                    10

     ======       ========      ========

       30                      25    (30-25)     5

Thanks,

Mohan

[KodandaPani_KV]

HI,

I hope you have issue with formula collusion ,

Eg:               Column A     Column B     Column C(A-B)

   Row E        10                    15                -5

   Row F         20                    10                10

                        ======   ========      =======

G(E+F)          30                      25    (30-25)5,(30+25) 55

If  you are expecting the result is 5, select G formula --> Go to formula Collusion --> get value from this formula..

[ccc_ccc]

Hi Reddy,

Do as like below

1. Select formulas and take properties and "Calculate result from this formula " , you can get desreid result.

Please paste Bex query designer , if your not able to find

Thank you,

Nanda

[Former Member]

Hi Reddy,

I see there is no option to subtract the results of two fields as explained above in SAP Bex. Anyway if the records are aggregated based on the fields you have dragged into the report, then use the calculated column to subtract the two columns. Anyway it is same.

Thanks and Regards,

Mahesh