Skip to Content
0
Oct 05, 2016 at 01:37 PM

#OVERFLOW ERROR IN WEBI

2364 Views

Hello All,

I have an issue on a particular column that need a percentage sign. The column has some rows with (#OVERFLOW) error. I have a code in place to convert the rows with the error to a string, in my case, "X". =If IsError([Key_Figure]) then 'X' else [Key_Figure]. The problem is when I apply this formula, the Format Number option disappears from the context menu when you right click on the column to create a custom formula. Is there a way to achieve both resolutions in a formula? To be able to remove the #OVERFLOW errors and then apply "%" sign to the column. I have tried it both ways, one after the other and vice versa with no luck.

Thanks,

Recca