Questions tagged [percent]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
25 views

Error in graph when trying to calculate lead % change month-to-month

I am trying to calculate the month-to-month lead % change for my company. I have the created month as a grouped column and I used the following formula to calculate the % change: (RowCount - ...
rts1994's user avatar
1 vote
1 answer
67 views

Default Percentage Value

I am trying to set a default value in a percent field where the final output is 5%. When I set the default value as 5, the UI shows 500%. However when I try to set the default value as .05 I receive ...
Josh Brandt's user avatar
0 votes
1 answer
1k views

How do I create a formula field that displays a text corresponding to a percentage score in another field

Currently, I have fields that have percentage values For instance, my communication score field that is scored based on a series of questions and has the formula I want to change the string in my ...
H4shBrown's user avatar
0 votes
1 answer
283 views

Percent Formula Field using MAX function (for single field)

I am trying to create a custom formula field (Percent) off of another custom formula field (Number) that self references the Number field to find the highest (MAX) value and to convert the Number ...
Chloe's user avatar
  • 11
0 votes
3 answers
2k views

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

I have a field of type Percent(3,2) named Sector__c.VatRate__c. I initialized it with anonymous apex withe values like 5.5, 10, 20, etc. The code looks like that : sec.VatRate__c = 10; update sec; ...
Emmanuel BRUNO's user avatar
0 votes
1 answer
266 views

Doing division on a Decimal returns 0 when trying to return a percent [duplicate]

When I run the following code, it will return a 0. It should return 50.00. System.Debug((100/200)*100); I'm certain this is a simple solution. But haven't been able to find out the reason why. I ...
thinker's user avatar
  • 1,432
0 votes
1 answer
2k views

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

Your input is appreciated, I'm creating a formula field called consumption is a result of dividing two numeric fields (Modified Usage, and Range) that will return a percentage of usage for example. If ...
Xperez's user avatar
  • 31
1 vote
1 answer
611 views

Formula field to calculate the percentage of days remaining

I have a custom formula field where I need to calculate the amount of days in the year * 100 \ 365 = % of days remaining. I've created the following formula: ROUND((365 - (CloseDate - DATE(YEAR(...
lemdev's user avatar
  • 427
1 vote
1 answer
9k views

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

Question about percentage fields in Salesforce. I know salesforce is saving these values as double precision. However, it seems the value saved is a whole number > 1 instead of 0 For example: //...
ZAR's user avatar
  • 2,043
6 votes
2 answers
2k views

How are percentage fields evaluated in process builder?

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....
ASGJim's user avatar
  • 131
7 votes
3 answers
10k views

Percentage in Lightning Components is not working correctly

It seems like Lightning isn't capable yet, to display percentage values intuitively. I used many different ways to display the value with input and output formatted as percentage and all the ...
itsmebasti's user avatar
  • 6,437
1 vote
1 answer
124 views

Percent type issue

I have percent field per. I am using this field in apex coding for calculation purpose. My formula in code is: Field_A__c = Field_B__c * Percent__c Suppose Percent__c = 75 (i.e 75%) and Field_B__c =...
p.samruddhi's user avatar
1 vote
0 answers
223 views

Percentage Formatting issue [visualforce] due to locale US vs Germany

I have a visualforce page and when i submit my commission percentage from a campaign plan in germany it turns 15.00% into 1.500,00% It is currently set up on the visualforce page like: <apex:...
Nebbyyy's user avatar
  • 838
0 votes
1 answer
130 views

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

Is this update is only for Flows (Like visual flows) and it does not have any impact on regular percentage field or formula field or formula field using percentage data? Note: I earlier posted THIS ...
Saumya Ranjan Satapathy's user avatar
2 votes
1 answer
339 views

Critical Update: Trust Percent Values in Flow sObject Variables Again

When I go thorough this critical update's description it says, Previously, our calculations on percent values weren’t always working as expected. We rolled out a partial fix earlier, and this ...
Saumya Ranjan Satapathy's user avatar