Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to change to the decimal column display unit on union report.

Received Response
21
Views
4
Comments
user12104316
user12104316 Rank 2 - Community Beginner
edited Aug 13, 2024 5:19PM in Oracle Analytics Cloud and Server

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.

Tagged:

Answers

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    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.

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    Also, try setting up the decimal places (or divide by 10000.00).

    BTW, when you say, you are getting incorrect output, what do you mean? Can you post an example of the input and output that you are getting,please?

  • user12104316
    user12104316 Rank 2 - Community Beginner

    Thank you Jerry. 

    "add a result column" option is working fine. This solution resolve my problem. 

  • user12104316
    user12104316 Rank 2 - Community Beginner

    Hi

       Actually we have several requests union together, some of them have positive measure, the others have negative measure.

       When we calculate '/10000' for each request on the same measure, the union result is not same as output 'all sum amount/10000'(sum all measure first, then do '/10000'  on total). That is what we confused.

    Thank you anyway.