Need to make some fields calculated.

[mr_innocentt]

Hello Friends.

Today i need your help in this form. Please check the image and my options are:

The calculations needed are below. I need the Acrobat Custom Calculation Script to put in these four fields, “Max IPC,” “Option 1,” “Option 2,” and “Design Center Costs.”

 CALCULATE MAX IPC - If “Down Payment Percentage” drop-down is “Less than 10%,” “Max IPC” should equal 3% of the “Base Price” value. - If “Down Payment Percentage” drop-down is “10% - 25%” “Max IPC” should equal 6% of the “Base Price” value. - If “Down Payment Percentage” drop-down is “25% or more” “Max IPC” should equal 9% of the “Base Price” value. CALCULATE OPTION 1 Option 1 equals 5% of “Base Price” value. CALCULATE OPTION 2 If “Max IPC” is equal or greater than $20,000, “Option 2” should display “$20,000.” Else If “Max IPC” is less than $20,000, “Option 2” should display the “Max IPC” value. CALCULATE DESIGN CENTER COSTS If “Max IPC” is less than $20,000, “Design Center Costs” equal 20,000 minus “Max IPC” Else if “Max IPC” is equal or greater than $20,000, “Design Center Costs” equal 0.

 

[Thom Parker]

What have you tried to do so far? 

[mr_innocentt]

Actually I did not do anything yet.

In image you can see that there are last four fields which I need to make them calcualted.mainly  focus is downpayment percentage filed.

CALCULATE MAX IPC - If “Down Payment Percentage” drop-down is “Less than 10%,” “Max IPC” should equal 3% of the “Base Price” value. - If “Down Payment Percentage” drop-down is “10% - 25%” “Max IPC” should equal 6% of the “Base Price” value. - If “Down Payment Percentage” drop-down is “25% or more” “Max IPC” should equal 9% of the “Base Price” value. CALCULATE OPTION 1 Option 1 equals 5% of “Base Price” value. CALCULATE OPTION 2 If “Max IPC” is equal or greater than $20,000, “Option 2” should display “$20,000.” Else If “Max IPC” is less than $20,000, “Option 2” should display the “Max IPC” value. CALCULATE DESIGN CENTER COSTS If “Max IPC” is less than $20,000, “Design Center Costs” equal 20,000 minus “Max IPC” Else if “Max IPC” is equal or greater than $20,000, “Design Center Costs” equal 0

[Thom Parker]

So are you interested in learning how to do this yourself? or did you just want free development? Cause you know, this is a little bit of work. Perhaps you should consider hiring a developer. 

[mr_innocentt]

I am interested in learning how to do it myself.

[Thom Parker]

Ok then, the best way to start is as simple as possible, i.e. a single calculation. The first calculation is the MaxIPC

Have you set any export values for the dropdown?

If you set them to the numbers used in the calculation, then there is no need for scripting. You can use the standard Product calcualtion or Simplified Field Notation. To this end, remove all spaces from your field names. 

The Option 1 calcuation can also be done with Simplified field notation. 

Here are two articles that will help you get started:

https://helpx.adobe.com/acrobat/using/manage-form-field-properties.html

https://acrobatusers.com/tutorials/print/how-to-do-not-so-simple-form-calculations/

[mr_innocentt]

Hello Thom,

Thanks for reply. let me try it first.