Additional Blogs by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
0 Kudos
454

I was keep receiving this issue/ticket from my client that as they export numeric dataset to excel sheet from Webi, They are keep getting same formatting errors.

Problem: As I export report from webi to excel value convert into text. I was told use =ToNumber ([Measure]) formula but all the values that are "0.00" or Null are now converting into text in MS 2013. I get green triangle error on excel

everything else seems to be taken as a number. my value is a [measure] object

Solution:

Use this formula.

=ToNumber(If(Isnull([measure]); 0 ; ([measure]).

That should resolve an issue.

-Arsalan Siddiqui

Please check 3386868 for the error

https://scn.sap.com/thread/3386868_

Note:  =FormatNumber() formula may not work in this case, Please check 3312221 for =FormatNumber()

http://scn.sap.com/thread/3312221