Skip to Content
0

Percentage calculation using variables

Oct 31, 2016 at 04:40 PM

15

avatar image
Former Member

Hi,

I am trying to calculate percentage based on variables created in two different queries. Age category is a variable and total members is another variable for query 1 and query 2. Is there a way to do it without having to create a new variable for each row?

Resulting percentage calculations -

Total percentage = 3146 / 123928 * 100 = 2.54%, the same needs to happen for the other rows but the calculations aren't correct.

As you see the total is correctly calculated but the rest are wrong. I have tried

5bkp1.png (3.6 kB)
auuz8.png (3.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers