Oracle Analytics and AI

user12104316

Dear guys

       We have a display unit issue here.

       There is a report with two union requests. Our request is to display the fact measure column in graph in tens of thousands unit.

       So we got this measure column calculated "/10000" for each union request, then the result comes out wrong number. If we remove the calculated "/10000", the result is back to correct number.

       Any other way to achieve this display request?

Thanks in advance.

Jerry Casey

Normally, the calculated column you describe should work correctly, even in a union query.  Have you set a aggregation method in the formula dialog?

Alternatively, you can do the calculation "outside" the union, at the header level.  When you highlight the header level of the union, there is a "add a result column" option.  You refer to the columns in the union as saw_0 through saw_x, starting with the left-most column.  If your measure column is the fourth from the left, your calculation might be "sum(saw_3)/10000", or just "saw_3/10000", etc., depending on the nature of the union.