Calculate -Ve values

[#1]

Hi all ,

What to do if want to calculate on only negative values,

Ex :  Arrears

        -10000

         20000

        -500

         3000

        -4500

i want to calculate only -Ve valuescan any one help.

Thanks

[amit_saini]

Hi,

Can do like this:

if(Sum(Field) < 0,  Sum(Field))

Thanks,
AS

[#3 · Accepted solution]

sum(if(Arrears<0,Arrears))

[#4]

Thank you Venkat Reddy.