I have a calculated control in my Nintex Form that uses the Lookup function to return a number value from another list. The formula I have used is below:
The "Updated Fee" column from LookupEntity list is also a calculated column, returning the sum of two columns in the same list, and it is set to return a number value to 2 decimal places.
However, the number returned in the Form via the lookup function varies between 1 and 5 decimal places.
Does anybody know the reason for this? And more importantly, a fix so that the lookup return is consistently to 2 decimal places?
Any help or comments most welcome!
Solved! Go to Solution.