on 10-31-2017 6:38 PM
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
Right click on the column-format number-and define the custom format as #.##
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank You Amit, I wasnt using the custom format as it was not needed but anyhow, thanks for the help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.