Nintex for SharePoint Forum
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Simple question, how can I round integer numbers to 2 places after the decimal within a workflow?
Cheers
mai-kel
@mai-kel .....Below is the RegEx:
^\d+(\.\d{1,2})?$
BTW, is there a reason you can't do this on a list column?
@kunalpatel : thanks for your reply, unfortunately it does not work here - what did I do wrong?!
Column is saving minutes (which is ok), but I need time in hours. But I do not want to add another column... table is already quite huge. : /
@mai-kel .....Can you tell me how you're getting that value? Is it some calculation in the workflow or is it coming from a form/list?
Hi,
Use a regular expression with an extract operation and this pattern:
\d\.\d{2}
Seems to work.
In regular expression syntax, \d is "a single digit". Therefore you need \d+ (one or more).