Perform Math on two Querys. Ex: (SUM($A) / sum($B)) *1000000

I created query A with 20 fields and query B with 6 fields. I need to take the sum of all the fields in A divided by the sum of all the fields in B and the multiply it 1000000 to get a ratio in part per million. I tried using the expression, but it is not working.

Hello @gwmurphy001,

Can you share what you’ve tried and what your data looks like?
Can you also explain what you mean by “it doesn’t work”? Is the result not what you expected (value)? An error?

Regards

1 Like