Skip to Content

#Error while using Tonumber function for a string

I am getting #error for Measure "Budget" I converted string to number. This works for P1, P2 but not for Budget. I think this is due to the cells are empty. Can you please help me to get this correct.

rzd5t.png (31.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 22 at 10:31 AM

    try this.

    =if(isnull([Budget]) or ([Budget]="")) then 0 else tonumber([Budget])

    Add comment
    10|10000 characters needed characters exceeded

    • This is the only workaround you have..in other way you have specifc requirement to display comma instead of dot and for doing that you have to use format number.