Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try this
Sum(Aggr(fabs(RangeMin($(vYoY_Chart), 0)), Item))
hi no that just gives the values in column D and the total is still saying 558150
Would you be able to share your qvw to see the issue? or images?
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
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