I am trying to use a Calculated Value on a form which performs a calculation based on a number of columns on the item.

One of those items is a Number column which has the 'Show as percentage (for example, 50%)' property checked. When I attempt to use the Item column or the Named Field it does not recognize it as a numeric value - I stripped down the formula and then added isNumeric(ColumnName) - and many permutations thereof which results in false.

There is no option for ConverttoNumber or similar. I have searched the forums and used Google to try to find a solution to no avail.