Skip to Content
Author's profile photo Arsalan Siddiqui

When exporting Webi to Excel I get triangle notification error in each excel cell.

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


Use this formula.

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

That should resolve an issue.

-Arsalan Siddiqui

Please check 3386868 for the error


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

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.