Skip to main content
Nintex Community Menu Bar

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

  • May 11, 2018
  • 1 reply
  • 88 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

Maisa
Forum|alt.badge.img+2
  • Novice
  • June 7, 2019

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