Negative numbers not summing up correctly

[ryanfoster84]

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

[sunny_talwar]

May be try this

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

[ryanfoster84]

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

[sunny_talwar]

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

[ryanfoster84]

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

[sunny_talwar]

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