Skip to Content
Former Member
Oct 31, 2016 at 04:40 PM

Percentage calculation using variables

72 Views Last edit Oct 31, 2016 at 04:50 PM 2 rev


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)