topic Re: sum negative and positive values in QlikView

sum negative and positive values

Sat, 29 Aug 2015 16:41:25 GMT

I have 4 fields that I need to sum, but this doesn't work since there can be many negative values, and that calculates wrong in in the script.

this is what the calc looks like in the load script:

Income - (Adjust+Payments+ Credits)) as Amount

Income is always positive. Adjustments, Payments and credits can be either positive and/or negative.

Thanks for quick reply

swuehl — Sun, 30 Aug 2015 22:34:07 GMT

How do you want to handle the negative values? Use the absolute values instead or setting the value to zero?

Income - (fabs(Adjust)+fabs(Payments)+ fabs(Credits))) as Amount

Income - (rangemax(Adjust,0)+rangemax(Payments,0)+ rangemax(Credits,0))) as Amount

jagan — Mon, 31 Aug 2015 01:41:19 GMT

Hi,

Can you attach some sample data and your expected result?

Regards,

Jagan.

svenkita — Mon, 31 Aug 2015 02:59:37 GMT

Try this

Income - fabs(Adjust) - fabs(Payments) - fabs(Credits)