• Global community
• Language:
• Deutsch
• English
• Español
• Français
• Português
• 日本語コミュニティ
Dedicated community for Japanese speakers
• 한국 커뮤니티
Dedicated community for Korean speakers
Exit
• Calculating Percentages

# Calculating Percentages

New Here ,
Dec 27, 2018 Dec 27, 2018

Copied

I have a mortgage site that I inherited. I can enter the down payment at a certain dollar value.  The owner wants to add the ability to either enter down payment (currently I have in site) or enter the percentage of a down payment.  Below is where I need to add the code and what was in there to start.

<tr>

<td valign="middle"><div align="right">Down Payment:</div></td>

<td valign="middle"><span class="style6"></span></td>

<td valign="middle"><span class="style6">

<cfinput name="dPayment" type="text" tabindex="23" size="15" required="yes" message="Please enter the down payment amount."  />

<!--- The down payment should be divided by the purchase price to determine the percentage of down payment (DP / PP = DP%) --->

</span></td>

</tr>

<!--- Entered 12/16/2018 --->

<tr>

<td valign="middle"><div align="right" class="style8">Or Enter</div></td>

<td valign="middle"><span class="style6"></span></td>

<td valign="middle"><span class="style6"></span></td>

</tr>

Need to know how to enter a percentage here. I am not a developer by any stretch of the imagination.  Any help offered would be appreciated.

Views

915

Report

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

Community Expert , Jan 01, 2019 Jan 01, 2019
 RasonJ77  wroteThat's fixed, now I get this when I put zero in for the dPayment. How to I set this to accept zero?  Again, I apologize for my lack of coding skills.

For consistency in the calculations, you could change the definition of dpPercentage, as follows

<cfset purchasePrice = form.purchase>

<cfset dPayment = form.dPayment>

...

20 Replies 20
Dec 27, 2018 Dec 27, 2018

Copied

 rasonj77  wrote I am not a developer by any stretch of the imagination.

This is a problem. Even if you are shown how to add HTML to add a form field that will accept a percentage, what are you going to add to the ColdFusion code that processes the submitted form? There is more to this than adding a bit of HTML.

I strongly suggest you hire a programmer.

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 ,
Dec 27, 2018 Dec 27, 2018

Copied

I know. I told the owner this in the beginning, but he thought I could do this since I know enough to be dangerous when writing code.

I do have all the other cfm pages that pulls everything together; and I have been able to figure things out in the past, but this one has me stumped.

Report

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

Copied

From what you've shown us, you could do the following in the action page of the form:

<cfset dpPercentage=(form.dPayment/form.pPrice)*100>

I have assumed dPayment and pPrice are input fields.

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 ,
Dec 29, 2018 Dec 29, 2018

Copied

Thank you, I will try that.

Jason Retherford

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 ,
Dec 31, 2018 Dec 31, 2018

Copied

heading the right path. Now I get "Element PERCENT is undefined in FORM"

<cfset purchasePrice = form.purchase>

<cfset dPayment = form.dPayment>

<!--- Added 12/31/2018 for precentage --->

<cfset dpPercentage = form.dpPercent>

Report

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

Copied

Unless there is an input field named dpPercentage, it won't be in the form scope.  The example BKBK​ presented sets a variable called dpPercentage, not a form field.

V/r,

^ _ ^

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 ,
Dec 31, 2018 Dec 31, 2018

Copied

That's fixed, now I get this when I put zero in for the dPayment. How to I set this to accept zero?  Again, I apologize for my lack of coding skills.

<cfif baseLoanAmount>

<cfset baseLoanAmount = (purchasePrice - dPayment)>

<cfelse>

<cfset baseLoanAmount = (purchasePrice * dpPercentage) / 100>

</cfif>

Report

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

Copied

ColdFusion is a loosely typed language, which means that by default, 0 = "0" and it also = "false".. so your <cfif baseLoanAmount> is basically saying "If the value of baseLoanAmount is greater than 0", which is false if the value IS zero, so it goes to the cfelse.  purchasePrice times zero divided by 100 is.. zero.

I'm leaving work, now.  Have a Happy New Year.

V/r,

^ _ ^

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 ,
Dec 31, 2018 Dec 31, 2018

Copied

Thank you; you too!

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 ,
Dec 31, 2018 Dec 31, 2018

Copied

Now, I have to go down a set other loan amounts through the rest of the page.  It looks like this may work. I will let you know how I made out.

Report

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

Copied

 RasonJ77  wroteThat's fixed, now I get this when I put zero in for the dPayment. How to I set this to accept zero?  Again, I apologize for my lack of coding skills.

For consistency in the calculations, you could change the definition of dpPercentage, as follows

<cfset purchasePrice = form.purchase>

<cfset dPayment = form.dPayment>

<!--- Added 12/31/2018 for percentage --->

<cfset dpPercentage = (purchasePrice-dPayment)*100/purchasePrice>

The baseLoanAmount then follows from:

<!--- Sufficient definition of baseLoanAmount --->

<cfset baseLoanAmount = purchasePrice - dPayment>

<!--- Alternative definition of baseLoanAmount --->

<cfset baseLoanAmount = dpPercentage*purchasePrice/100>

Hence, when dPayment is zero, baseLoanAmount is the purchasePrice.

Happy New Year!

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 ,
Jan 02, 2019 Jan 02, 2019

Copied

so I could have both of these in there at the same time?

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 ,
Jan 02, 2019 Jan 02, 2019

Copied

ok, that worked (thank you!). Now it is causing another issue; since I have the baseLoanAmount set twice, the form is only looking at the first one. how do i get it to pick one or the other when running the form for mLoanAmount?

<!-Calculation for Mortgage Loan Amount->

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 ,
Jan 02, 2019 Jan 02, 2019

Copied

<cfset baseLoanAmount = (purchasePrice - dPayment)>

<cfset baseLoanAmount = (dpPercentage*purchasePrice) /10>

<!---Calculation for Mortgage Loan Amount--->

<cfset mLoanAmount = (baseLoanAmount + upFrontMIP)>

Report

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

Copied

I called the second one,



So use the one or, alternatively, the other.

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 ,
Jan 03, 2019 Jan 03, 2019

Copied

that didn't work. it is only taking the first one. I can't get it to take one if there is a down payment entered like (10,000) or percentage like (10). Under Down Payment, I have a row to enter the percentage. I took it back out before I snipped this image.

Report

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

Copied

 RasonJ77  wrotethat didn't work. it is only taking the first one.  I can't get it to take one if there is a down payment entered like (10,000) or percentage like (10).  Under Down Payment, I have a row to enter the percentage. I took it back out before I snipped this image.

This confuses me a bit. To get back to the beginning, a form has been submitted. The definitions

<cfset purchasePrice = form.purchase>

<cfset dPayment = form.dPayment>

are on the action page of the form. These are required fields, so dPayment is available. If you want percentage to also be available here, then you should also include it as a form field.

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 ,
Jan 06, 2019 Jan 06, 2019

Copied

it is in the form. I have both in there. Below is what is in the form and the added percentage.

Report

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

Copied

Then I shall assume the form fields are, respectively, purchase, dPayment and dpPercentage. You could then proceed as follows:

<cfset purchasePrice = form.purchase>

<cfset dPayment = form.dPayment>

<cfset dpPercent = form.dpPercentage>

<cfif isNumeric(dpPercent)><!---If percentage submitted, use it to calculate down-payment --->

<cfset dPayment = dpPercent*purchasePrice/100>

<!---Convert to \$ amount --->

<cfset dPayment = LSNumberFormat(dpayment, "\$__.__")>

<cfelseif isNumeric(dPayment)><!---If down-payment submitted,  use it to calculate percentage --->

<cfset dpPercent = (purchasePrice-dPayment)*100/purchasePrice>

</cfif>

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 ,
Jan 06, 2019 Jan 06, 2019

Copied

LATEST

You were correct, I was looking at it wrong! it is working as it should now. Thank you so much!