Skip to main content
D
David J. Myers
Participant
May 9, 2020
Answered

Base Cost + Additional Cost Per Unit Beginning with 4th Unit

  • May 9, 2020
  • 2 replies
  • 1009 views

I'm struggling to work out a simple script to calculate the total cost after a specific number of units are added, but remain at base cost for the first 3 units.

 

For instance:

  • Cost of 1st Unit = $475 (Base cost.)
  • Cost of 1st Unit + 2 Additional Units (Total of 3 Units) = $475 (Same cost as base cost.)
  • Cost of 1st Unit + 3 Additional Units (Total of 4 Units) = $525
  • Cost of 1st Unit + 4 Additional Units (Total of 5 Units) = $575

etc.

 

The Excel formula that gives this result is:

 

=475+MAX(0,4-3)*50

 

Of course, that works in Excel, but not Acrobat.

 

The JavaScript code I've attempted is:

 

var ffcondo = Number(this.getField("FFCondo").value);
var pgcountcondo = Number(this.getField("PGcountCondo").value);
if (pgcountcondo == "") event.value = "";
else event.value = (ffcondo+(pgcountcondo-3)*50) <= 475 ? 475 : (ffcondo+(pgcountcondo-3)*50);

 

 

Unfortunately, the results I get with that JavaScript code are unreliable. Sometimes the result is correct; more often it's wrong. I'm very much a JavaScript novice. Attached is the file I'm working with.

This topic has been closed for replies.
Correct answer David J. Myers

After guidance from Bernd_Alheit and try67, this is the JavaScript I ended up using:

var pgcountcondo = Number(this.getField("PGcountCondo").value);
if (pgcountcondo == "") event.value = "";
else {
var v = (475+(pgcountcondo-3)*50);
event.value = Math.max(v, 475);
}

 

2 replies

D
David J. MyersAuthorCorrect answer
Participant
May 9, 2020

After guidance from Bernd_Alheit and try67, this is the JavaScript I ended up using:

var pgcountcondo = Number(this.getField("PGcountCondo").value);
if (pgcountcondo == "") event.value = "";
else {
var v = (475+(pgcountcondo-3)*50);
event.value = Math.max(v, 475);
}

 

Bernd Alheit
Community Expert
Bernd AlheitCommunity Expert
Community Expert
May 9, 2020

For the calculation of field "FFCondo" you use the value of field "FFCondo".
Why does you use this recursive calculation?

D
David J. MyersAuthor
Participant
May 9, 2020

Bernd:

I'm not entirely sure what you're asking. I normally don't write much JavaScript, and therefore I'm a novice in this area.

Perhaps linking to a Google Sheet that shows explicitly what I'm attempting to do will help:

CONDOMINIUM DEPOSIT WORKSHEET

Bernd Alheit
Community Expert
Bernd AlheitCommunity Expert
Community Expert
May 9, 2020

Why does you use for the calculation of field "FFCondo" the value of field "FFCondo"?

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