5 Replies Latest reply on Oct 25, 2013 5:15 PM by SriniVEERAVALLI

# Is it possible to force a single decimal in a specific column in the formula?

I am working with a report where the decimal placement needs to change in different columns of the same row (due to unions). Therefore, I am looking to show only 1 digit after the decimal point in one cell out of the whole row. Is there a formula I can use that will override the decimal settings made in the column properties tab? I tried to truncate and round but it does not show the proper number of digits after the decimal.

If anyone knows of a solution or workaround, that'd be great!

Thanks

• ###### 1. Re: Is it possible to force a single decimal in a specific column in the formula?

cast(col as double)

or

col*1.0

or

column properties->Data format->Number choose 1 at decimal places

1 person found this helpful
• ###### 2. Re: Is it possible to force a single decimal in a specific column in the formula?

Hi srini.

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.

• ###### 3. Re: Is it possible to force a single decimal in a specific column in the formula?

It may not be workout since the column formats are set to column level not by a specific row wise.

• ###### 4. Re: Is it possible to force a single decimal in a specific column in the formula?

I think if I show you pictures it might be easier to understand.

http://imgur.com/a/7o5bL

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...

• ###### 5. Re: Is it possible to force a single decimal in a specific column in the formula?

send pic to sveerava at gm