cancel
Showing results for 
Search instead for 
Did you mean: 

Decimal points while scheduling a webi report

former_member203111
Participant
0 Kudos

HI,

I have a webi report built on BEx and all the numeric key figures/measures are set for two decimal points in the report but when i schedule the webi report in excel format, all the decimal point formating are lost in the excel after the broadcast report is received by the users.

For example: in the BEx and Webi sales revnue is 100.25 but when it is scheduled and sent in excel it looks like 100.246203800 or so on.

Is there a setting i can control the decimal points to be exactly the same what i have in the actual report.

Please advise

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

amitrathi239
Active Contributor
0 Kudos

Right click on the column-format number-and define the custom format as #.##

Answers (1)

Answers (1)

former_member203111
Participant
0 Kudos

Thank You Amit, I wasnt using the custom format as it was not needed but anyhow, thanks for the help.