Skip to main content
Nintex Community Menu Bar

Forms lookup formula returning number values with extra decimal rounding

  • June 1, 2020
  • 2 replies
  • 29 views
thesturl
Forum|alt.badge.img+1

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:

 

lookup("LookupEntity","Entity",parseLookup(AuditedEntity,True),"Updated Fee")

 

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!

    2 replies

    Simon Muntz
    Nintex Partner
    Forum|alt.badge.img+23
    • Simon MuntzNintex Partner
    • Nintex Partner
    • June 1, 2020
    Hi,

    Why this is happening i could not tell you but you could try wrap your lookup in a round() runtime function and specify the number of decimal places to work around the issue.
    We provide Nintex Training & Consulting - https://www.definiti.com.au/
    thesturl
    Forum|alt.badge.img+1
    • thesturl
    • Author
    • June 15, 2020
    Amazing - that worked a treat.
    For completeness, my updated formula is below:

    round(lookup("LookupEntity","Entity",parseLookup(AuditedEntity,True),"Updated Fee"),2)

    Cheers!
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement