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