I have 3 queries(lists) and each have a total column
And at the end of the report, I have to calculate a percentage with the three totals from differtent queries.
q1: total1
x
q2: total2
y
q3: total3
z
I am trying to create a query calculation at the end of the report : q3.total3/q1.(total1+q2.total2)
but i am facing errors that i cannot create as there is no cross join.
Please advice. Can I do this or Is there any other way
Thanks in advance.
Do all 3 queries have the same output columns? Is this something you could union together so that you could do the needed calculation in that one single resulting unioned query?