1 person found this helpful
cast(col as double)
column properties->Data format->Number choose 1 at decimal places
None of these options work unfortunately.
Here is my situation:
I have a pivot table report and my measures are on the row level. In my columns, I have months for the whole year, with the last 2 columns being variation columns. For example, Volume is the first row and the column properties is set at 0 for decimal places because the users want to see volume as whole numbers. However, in the last column, they want to see a variation % with 1 number after the decimal. The last column is unioned and I am hoping to find a solution that lets me force the output to be in the format that I would like.
It may not be workout since the column formats are set to column level not by a specific row wise.
I think if I show you pictures it might be easier to understand.
If you look in the first picture, you will notice that my volume row has the decimal number set to 0 to show only whole numbers. However, you will also see that the last column, union 5, is a % variance from union 3 vs union 4. In union 5, I am hoping to enter something in the formula for that column to force OBIEE to display a number in the following format XX.X instead of XX.
I haven't had any luck using truncate, round, or cast unfortunately...
send pic to sveerava at gm