Elena Posted November 26, 2015 Report Share Posted November 26, 2015 Hello, I am trying to perform a ratio calculation out of the two aggregate numbers that I have on my tabular report. The first aggregate is a weighted average of a set of numbers in column1. The second aggregate is a total sum of a set of numbers in column2. I would like to calculate the percentage diffrence between the two aggregate numbers. Is that possible with another Caspio aggregate function ? Is there a javascript though that can achieve this? I shall appreciate as always...all the help. Elena Quote Link to comment Share on other sites More sharing options...
0 Jan Posted November 30, 2015 Report Share Posted November 30, 2015 Hello Elena, As far as I know, you can use several fields in an Aggreagation. For example, if can use the following formula: SUM(field1)/SUM(field2)*100 I hope, it helps. Quote Link to comment Share on other sites More sharing options...
0 Elena Posted December 5, 2015 Author Report Share Posted December 5, 2015 I believe I did not explain properly. I am not using fields at this point, but rather aggregate fields. Two of them. What I wish to do is to calculate the difference between these two aggregated fields. Thank you Jan. Quote Link to comment Share on other sites More sharing options...
0 Jan Posted December 5, 2015 Report Share Posted December 5, 2015 Hi Elena, I apologize if my answer was not clear. I propose to create one more aggregation field and enter the formula that calculate difference. What are the formulas of first and second Aggregation fields? Is it just SUM of any field or is it more complex? Quote Link to comment Share on other sites More sharing options...
0 Elena Posted December 7, 2015 Author Report Share Posted December 7, 2015 Hi Jan, Both aggregates are average of their respective fields. Elena Quote Link to comment Share on other sites More sharing options...
0 Elena Posted December 7, 2015 Author Report Share Posted December 7, 2015 oh I must add, one of the fields is in fact a calculated field, that I was averaging in aggregate. Quote Link to comment Share on other sites More sharing options...
Question
Elena
Hello,
I am trying to perform a ratio calculation out of the two aggregate numbers that I have on my tabular report.
The first aggregate is a weighted average of a set of numbers in column1.
The second aggregate is a total sum of a set of numbers in column2.
I would like to calculate the percentage diffrence between the two aggregate numbers. Is that possible with another Caspio aggregate function ?
Is there a javascript though that can achieve this?
I shall appreciate as always...all the help.
Elena
Link to comment
Share on other sites
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.