Calculated Value with display as percentage field - Column is Number, but not recognized as Numeric

  • 11 May 2018
  • 1 reply
  • 39 views

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.

 

1 reply

Badge +1

Try to change your Column as a text field it will work

Reply