percentage formulas

[Rosie_Courtney]

Help! I need to create a formula for getting the percentage of something. Can you help?

I need to know how to get the percentage of this.

Here is what I got.

CoverageRevenueTotal / NetRentalRevenueTotal

Thank you,

Rosie Courtney

Handicap Vehicle Specialists

AVA Wheelchair Van Rentals of Phoenix

rosie@handicapvehicle.com

[paulk07]

if (NetRentalRevenueTotal.rawValue != 0) {

(CoverageRevenueTotal.rawValue / NetRentalRevenueTotal.rawValue)*100;

} else {

// Set field to blank (or whatever else you would want) here

}

[Rosie_Courtney]

I am not sure I am understanding what you are saying. So let me explain my form a little better or at least try too.

I need to know the Coverage % of the Revenue and the formula I thought would work in formcalc is

CoverageRevenueTotal / NetRentalRevenueTotal

But it is not coming up with the right percentage. What am I doing wrong?

[paulk07]

My solution is a java script using the calculate event.  I'm using the rawValue of the data entered by the user.  Copy and paste it in your form or a test form.  Punctuation and brackets matter

[Rosie_Courtney]

Paul,

These totals will constantly be changing