• Help needed calculating a field with its answer be...

# Help needed calculating a field with its answer being a percentage based on another field

New Here ,
Apr 23, 2022 Apr 23, 2022

Copied

How do I make a calculated field that the result is a percentage based off of the amount of another field? For example: "Price" is a calculated field which is the sum of several other fields. I need a formula to calculate in the "Downpayment" field that is 10% if the sum of the price field is \$3000 or less and 15% if the sum is \$3000.01 or more. I hope I explained that correctly.

TOPICS
Create PDFs

Views

68

Likes

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
3 Replies 3
Apr 23, 2022 Apr 23, 2022

Copied

As custom calculation of percentage field use this:

var f = Number(this.getField("Price").value);
var p10 = f*.10;
var p15 = f*.15;
event.value = f<=3000 ? p10 : p15;

Likes

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
Apr 26, 2022 Apr 26, 2022

Copied

LATEST
Thank you so much! That works perfectly!

--
*Lew Anne Mayhew & Shanna Clark*
*Mayhew and Sons Inc*
*1033 Dozer Ln *
*Bedford Va 24523*
*540-537-2584*
*540-312-9418*

Likes

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
Apr 26, 2022 Apr 26, 2022

Copied

Thank you so much! That works perfectly!

Likes

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Resources