Hi All,
I am trying the below number format in Webi.
Eg: Original value = 230562.05
Webi has to display = 231
After export to excel it has to display in front end view has 231 and after click that specific cell it has to show original figure 230562.05
Note: Directly in excel I tried using this format #,##0, and working fine, but not in WEBI
Kindly advise on the same.
Regards,
R. Saravanan
right click on the column-format number and define the custom format to #,##0 and try
You already have an active moderator alert for this content.
Hi,
I have done the same but no result.
Anyone done this requirement? Kindly help on this.
Instead of using custom format use predefined format.
Hi Amit,
Thanks for your reply.
I have already tried and below result not getting.
I have tested and it's working for me.can you share the screenshot after applying the format how values are coming in webi and excel.
Add comment