Skip to Content
avatar image
Former Member

Percentage calculation using variables


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)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers