Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
you can do something like this :
Sum({$<Fieldname={">0"}>}Fieldname) for positives
Sum({$<Fieldname={"<0"}>}Fieldname) for negatives
Hi,
you can do something like this :
Sum({$<Fieldname={">0"}>}Fieldname) for positives
Sum({$<Fieldname={"<0"}>}Fieldname) for negatives
Thank you
Regards,
Prajna
See the attached file