Simple SUM question

[benz84]

Hello,

I want to display the sum of all numbers in a column on the results page. The numbers are currency. I prefer for the sum to be showed at the top of the page or above the respective column and denote that it is the sum of that column. Any code as to how to achieve this?

[bahar_vm]

Hello,

You can take a look at the sample Java Scripts at viewforum.php?f=14. There is one "JS: Calculate column sum in the result page" which seems to be what you are asking for.

Best,

Bahar M.

[jsinger]

I've tried to use that sample script. I set up a table to follow the requirements to be used "as is" and it does not work. That script is faulty.

[paulbalas]

I have the same problem. The script works, but creates a total of '0'. Also, I'd like to know how to best create a 'group by' sum of detail data? Can we create our own views that have group by in the sql?

[dragonfly]

I do not think the script is faulty, it works for my app. It just needs to be customized according to your results table and column indexes.

For example if you have a download option enabled on your results page you need to reference the results table with index 2 because it will be the third table in the page.

I would suggest if you use Firefox browser and add Firebug add-on which shows you the errors on the page. This way you can better address the issue as it spots the lines you have errors on your code. After all, even if you missed to change or typed wrongly of a single field name, it won't work.

[hbasluc]

If you have your columns format to show as currency, the reason the script is Displaying a total of "0" is that each time the code comes to an element in the designated column, it's not accounting for the currency symbol (e.g. - "$", "€") and punctuations (e.g. - "," in the thousands, millions... place) and is returning a value of "0".

Remedy to remove the symbols for NaN ("Not a Number") Clarification:

replace -

"

v_rev = cells[COLUMNNUMBER].innerHTML;

if ( v_rev != " " && !isNaN(v_rev.substr(1)))

"

with -

"

v_rev = cells[COLUMNNUMBER].innerHTML;

v_rev = v_rev.replace(/,/gi, '')

v_rev = v_rev.replace(/$/gi, '')

v_rev = v_rev.replace(/€/gi, '')

if ( v_rev != " " && !isNaN(v_rev))

"

[hbasluc]

One last modification:

Replace:

"

v_rev = v_rev.replace(/,/gi, '')

v_rev = v_rev.replace(/$/gi, '')

v_rev = v_rev.replace(/€/gi, '')

"

With:

"

v_rev = v_rev.replace(",", "")

v_rev = v_rev.replace("$", "")

v_rev = v_rev.replace("€", "")

"

[danieljones2006]

The problem is it still creates a total of '0', so anyone please help out.

[ChrisJ]

Think the initial issue is realized in 6.9 release.

Now you can add "Aggregation" (SUM) and show it above table, below table, as well as both above and below.

http://howto.caspio.com/release-notes/w ... e-6-9.html

to paulbalas> Also grouping is enabled and you can sum values in the 1st group.

[ChrisJ]

BTW. Result total can be formatted to be displayed as Currency (EUR, USD, etc. depending on localization settings).