How to change to the decimal column display unit on union report. — oracle-tech

    Forum Stats

  • 3,702,305 Users
  • 2,239,629 Discussions
  • 7,835,898 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

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

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:
Jerry Casey

Best Answer

  • Jerry CaseyJerry Casey Posts: 271 Silver Badge
    edited March 5 Accepted Answer

    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.

Answers

  • Jerry CaseyJerry Casey Posts: 271 Silver Badge
    edited March 5 Accepted Answer

    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.

  • SonPat99SonPat99 Posts: 238 Red Ribbon
    edited March 6

    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?

  • user12104316user12104316 Posts: 9
    edited March 6

    Thank you Jerry. 

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

    Jerry Casey
  • user12104316user12104316 Posts: 9
    edited March 6

    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.

Sign In or Register to comment.