Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

I do a LOT of work with percentage fields… calculating margins, markups, markdowns, fees, discounts etc.

...

No.

Field Type

Start Value

End Value

1

Update the record with the exact value from the same field on the Get Record

2.55

2.55

2

Update the field with the passed in variable percent

2.789

2.789

3

Update the field with the input percent

10.543

10.543

4

Update the field with the formula percent. The formula is just the value of the exact field that is being updated, from the Get Record.

8.253

0.083

Passed in Variable then into a formula (not pictured)

2.789

2.789

...

End Value

...

WHY oh WHY is there a difference! Why when I use a Variable in a formula does it stay as the full number, but using a value retrieved from a record in a formula converts it to the percentage???

Note

If you need to deal with percentage fields in a formula, IF the value comes from a Get Record ensure you multiply them the value by 100 before using them it in an Update in Flow. if the value comes from a Variable and the Variable is then used in a formula, don’t multiply it by 100. Confusing!

This may have seemed obvious, but it wasn’t until I went through it step by step.