Percentage calculation using variables

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