Search Results
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 |
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. …
1
vote
Default Percentage Value
You must include a leading zero, as in 0.05.
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 …
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 …
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.
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 …
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. …