Sum value based on + and - values

[#1]

Hi All,

can anyone help me out in building logic/ writing exoression.

I want to sum the value from one field having positive and negative values.

the data in field is like this

Fieldname

500

550

-44

89

-456

I want to classify positive and negative values into two expressions.

can i use set analysis..like operator? what couls best way to represent?

Thank you

Regards,

Prajna

[christophebrault · Accepted solution]

Hi,

you can do something like this :

Sum({$<Fieldname={">0"}>}Fieldname) for positives

Sum({$<Fieldname={"<0"}>}Fieldname) for negatives

[#3]

Thank you

Regards,

Prajna

[er_mohit]

See the attached file