Rounding numbers 2 places after decimal within workflow

[mai-kel]

Simple question, how can I round integer numbers to 2 places after the decimal within a workflow?

Cheers

mai-kel

[mai-kel]

Regular expression anyone?! 🙂

[kunalpatel]

@mai-kel .....Below is the RegEx:

^\d+(\.\d{1,2})?$

BTW, is there a reason you can't do this on a list column?

[mai-kel]

@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. : /

[kunalpatel]

@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?

[SimonMuntz]

Hi,

Use a regular expression with an extract operation and this pattern:

\d\.\d{2}

Seems to work.

[mai-kel]

Hi Simon,

This also trims left from the separator, I tried 11.234567 and received also 1.23 back.... 😞

Cheers
mai-kel

[beckettj]

In regular expression syntax, \d is "a single digit". Therefore you need \d+ (one or more).

[SimonMuntz]

@beckettj is correct.

The pattern should be.

\d+\.\d{2}