I'm having trouble figuring out how percent fields, specifically formula percent fields, are evaluated in criteria for process builder. We have a basic process using the "Conditions are met" criteria.
The above criteria stopped working at some point – I don't know exactly when. I know salesforce pushed out an update that changed the way percent values were handled in process builder: trust percent values…
Also, based on everything I've read, percent fields should be referred to as field value / 100 (e.g. 90% = 0.9).
When troubleshooting this issue, I tried changing the value to 50 instead of .5, which worked. I can't find any documentation anywhere saying this is how it should work. I'm afraid to go through all my processes and update them with this logic if there's something I'm missing? Should we reference percent fields as the whole value that's displayed in a percent field moving forward?
Also, for testing, I had the process update two test fields with the percent paid formula field value in the condition. One was a number field, the other a percent field. The process updated both fields with the same value – e.g. if the percent paid formula field was 40%, it would put 40 in both the number and percent fields.
Best Answer
Somewhere in the back of my mind when studying for my Admin exam, fields were stored a numbers and SF converted them to decimals when using. So 45% was stored as 45. I tried the University of Google and did not find an answer. Just a hunch on my part.