Simple Expression

[#1]

Hi All,

My expression,

SUM('BRO_ORC'+'AGE_ORC'+'GRO_ORC'+'DIRECT_ME')-('ORC_COM')

where 'BRO_ORC','AGE_ORC,'GRO_ORC, 'DIRECT_ME' and 'ORC_COM' are field name of my table.

Even expression status shows "OK" , the calculation is not done.

Regards,

Priyantha.

[alexandros17]

Try This

SUM(BRO_ORC+AGE_ORC+GRO_ORC+DIRECT_ME-ORC_COM)

or this

SUM(BRO_ORC+AGE_ORC+GRO_ORC+DIRECT_ME)-SUM(ORC_COM)

let me know

[#3]

Both are not working.......

[alexandros17]

Replace sum with rangesum so you have:

rangesum(BRO_ORC,AGE_ORC,GRO_ORC,DIRECT_ME)

[jonathandienst]

Hi

If any one field is null, the row will evaluate as null, regardless of the value of the other fields. RangeSum() will fix that. Your complete expression will then be:

Sum(RangeSum(BRO_ORC, AGE_ORC, GRO_ORC, DIRECT_ME, -ORC_COM))

HTH

Jonathan