Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options answers only not deleted user 2984
4 votes

Salesforce doesn't save percentage fields as a decimal between 0 - 1?

If you want to use the value in Apex, Lightning, Visualforce, etc, you need to divide the percent field by 100. …
sfdcfox's user avatar
  • 502k
1 vote

Default Percentage Value

You must include a leading zero, as in 0.05.
sfdcfox's user avatar
  • 502k
1 vote
Accepted

How to write formula field that returns a percentage to show amount at or below 100%

I realize you say you're not dividing by zero, but just to be sure, let's check for blank values first, then we'll optimize: IF( ISPICKVAL(Range__c,""), null, MIN(1,Modified_Usage__c/VALUE(SUBSTI …
sfdcfox's user avatar
  • 502k
1 vote
Accepted

Is there any impact for the existing values if we change the length of the percent fields?

Number fields store data with very high precision. Changing the length or precision won't affect any records in the database. Lowering the length won't affect the display, but changing the precision w …
sfdcfox's user avatar
  • 502k
0 votes
Accepted

Critical Update: Trust Percent Values in Flow sObject Variables Again - 2

It's for flows, which were causing percentage fields to scale down incorrectly between variables. Normal formulas work as they always have, are not broken, and will not be affected by the update.
sfdcfox's user avatar
  • 502k
1 vote
Accepted

Critical Update: Trust Percent Values in Flow sObject Variables Again

How to access Opportunity2.Probability object? Is it a typo? No, they're variable names. It doesn't help that they named the first variable Opportunity, which is likely the source of your confusi …
sfdcfox's user avatar
  • 502k
2 votes

How are stored percentage fields ? They don't always return the same value

Formulas behave like Excel formulas, and if you format a cell as a Percent, Excel automatically handles conversion of percentages so your formulas "just work." … In the SOAP API, a percent is expressed as written on a screen. I'm not entirely sure why, but it may have to do with the fact that there is no xsd:percent data type in the WSDL language. …
sfdcfox's user avatar
  • 502k