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