topic Re: Negative numbers not summing up correctly in QlikView

Negative numbers not summing up correctly

ryanfoster84 — Tue, 23 May 2017 15:52:20 GMT

Hi, I am looking assistance with an issue I am encountering when trying to sum up negative numbers. I have a spread sheet which is the output of my table (can not share the application as it contains customer data) and the column in question that is proving troublesome is column L and the formula behind it is as follows:

=(SUM(Aggr(FABS(IF($(vYoY_Chart)<0,$(vYoY_Chart),0)),[Commodity Description])))

the formula for $(vYoY_Chart) is:

(Sum(
{$<
[Month] = ,
[Year] = {$(vMaxYear)}
>}
Volume))
-
(Sum(
{$<
[Month] = ,
[Year] = {$(vPreviousYear)}
>}
Volume)).

the total should be -665,666 (seen in column D in the spreadsheet) but my formula is showing -558,150 which is messing with my percentages.

thanks,

ryan

Re: Negative numbers not summing up correctly

sunny_talwar — Tue, 23 May 2017 15:58:01 GMT

May be try this

Sum(Aggr(fabs(RangeMin($(vYoY_Chart), 0)), Item))

Re: Negative numbers not summing up correctly

ryanfoster84 — Tue, 23 May 2017 16:02:31 GMT

hi no that just gives the values in column D and the total is still saying 558150

Re: Negative numbers not summing up correctly

sunny_talwar — Tue, 23 May 2017 16:06:58 GMT

Would you be able to share your qvw to see the issue? or images?

Re: Negative numbers not summing up correctly

ryanfoster84 — Tue, 23 May 2017 16:17:51 GMT

as mentioned above I am unable to share the application I have provided a spreadsheet of the table. so if you sum up the negative values in column d you will see that its -665,666

Re: Negative numbers not summing up correctly

sunny_talwar — Tue, 23 May 2017 16:22:22 GMT

Ryan - May be look at this link and see if this can provide you something which allows you to share your app

Preparing examples for Upload - Reduction and Data Scrambling‌

Unless you share a sample, it will be very difficult to know what might be wrong. If you still cannot share, then may be someone else can offer better help.

Best,

Sunny