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.