Incorrect calculations in Crosstab

[JuliaM]

Hi all,

I have a union query from relational DB - product, sale type(domestic, export) as rows. Quantity and Sale as measures. I union current month and Year-to-Date queries. I need to calculate price as Qty/Sale.
Problem is - the calculated price is not correct. I tried calculating price in each query, or calculate price in the union query, both get different kind of incorrect results.

Help please!
Thank you.

[Lynn]

I think the union is the appropriate place to have the calculation.

Maybe it has to do with the aggregation properties in your union query. You could try to set the quantity and sale as total and set the price query item as calculated.

[JuliaM]

Oh so simple  :) Thank you Lynn, it worked!

[Lynn]

Yay! Glad it worked  :)