data item problem

[psandhya408]

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.

[squish88]

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?