Skip to main content
T
therese23689927ey6n
Participating Frequently
March 21, 2022
Answered

creating a formula to get a percentage

  • March 21, 2022
  • 3 replies
  • 2955 views

i am trying to calculate a cell in my form which will allow an automatic fill in from a percentage of a total amount from another cell. How do I accomplish this. 

This topic has been closed for replies.
Correct answer try67
Façade_Improvement_Checklist_Fillable_2022.pdf

OK, you didn't explain it clearly. You want the result to show under "Total Funding Request 50 of cost up to 5000"... Use this code as that field's custom calculation script:

 

var v = Number(this.getField("CostTotal Cost").valueAsString);
event.value = Math.min(v/2, 5000);

3 replies

M
Melissa259944217f10
Participant
September 7, 2022

Hi experts,

I have a simple request to get the % increase  to be stated in %'s from  two columns from the year 2022 to year 2023 columns

thanks

 

 

Dave Creamer of IDEAS
Community Expert
Dave Creamer of IDEASCommunity Expert
Community Expert
September 7, 2022

You should start a new discussion specific to your question.

David Creamer: Community Expert (ACI and ACE 1995-2023)
Dave Creamer of IDEAS
Community Expert
Dave Creamer of IDEASCommunity Expert
Community Expert
March 21, 2022

Do you want the "Total Funding Request" to be 1/2 of the "Total Cost" with a maximum of $5000?

David Creamer: Community Expert (ACI and ACE 1995-2023)
T
therese23689927ey6nAuthor
Participating Frequently
March 23, 2022

Yes that is exactly what I want.

try67
Community Expert
try67Community Expert
Community Expert
March 21, 2022

What's the name of the other field, and what percentage do you want to show?

T
therese23689927ey6nAuthor
Participating Frequently
March 22, 2022
Hello, the name of the other field is" Total Funding Request 50 of cost up
to 5000". I want to show 50% of the cost but nothing over $5000.00.
$5000.00 is the maximum.

Thanks

Therese
try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
March 23, 2022
Façade_Improvement_Checklist_Fillable_2022.pdf

OK, you didn't explain it clearly. You want the result to show under "Total Funding Request 50 of cost up to 5000"... Use this code as that field's custom calculation script:

 

var v = Number(this.getField("CostTotal Cost").valueAsString);
event.value = Math.min(v/2, 5000);

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices