#Error In Webi Converting String to Number

[siva_ram20]

Hi Team,

I have created the Dimension in the Universel which having datatype is a string but present the data in the Numeric values whereas in the database-level that objects having a datatype is Varchar2(49).When I use this Dimension in the report level it is generating # Error. could you please help on this issue

[amitrathi239 · Accepted solution]

try to change the datatype "Number" in universe and try.

[former_member198519]

Can you check if there is any space in the value. try to use this, see if that works:

=If(Not(IsError(ToNumber(Trim([Dimension Object))));ToNumber(Trim([Dimension Object])))