Formatting Numbers and Decimal places

building reports webintelligence
1

Hi

I have the following data set that returns numbers such as 6.3, 2, 12.34, etc
Can I format the cells in webi so that the data returns: 6.3, 2.0, 12.3

I need WEBI to add zeros to whole numbers so that the decimal place is always to the tenths place, and round when the decimal place is at the hundreths or thousandths.

All numbers should be displayed as decimals in the tenths place

I tried the format number option but it has not worked so far, I am probably missing something

Thanks

bobboard (BOB member since 2009-03-04)

2

I should mention that the numbers are in a cross tab and are the result of a difference calculation

For Example, I have a Measured value defined that subtracts two numbers to get the number displayed in the cross tab. 8-6 = 2
2 is displayed in the crosstab and I need it to display 2.0

Thanks

bobboard (BOB member since 2009-03-04)

3

Figured it out… Used the ToNumber function in data formulas

bobboard (BOB member since 2009-03-04)