I am having a problem formatting some numbers in a UNION query.
I have two simple queries which return basic scores and their average for a specific period. I have each query rounds the averages so I don't get any decimals (EX 9.3333=9). When I use a UNION query to get the two separate queries together, it seems to be ignoring the formatting of the original queries and shows the decimal numbers (EX 9.3333).
How do I format the UNION query to retain the rounded number (on export as well)?
I have two simple queries which return basic scores and their average for a specific period. I have each query rounds the averages so I don't get any decimals (EX 9.3333=9). When I use a UNION query to get the two separate queries together, it seems to be ignoring the formatting of the original queries and shows the decimal numbers (EX 9.3333).
How do I format the UNION query to retain the rounded number (on export as well)?