Highlighted

percentage formulas

Rosie_Courtney

09-01-2012

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

Replies

Highlighted

paulk07

09-01-2012

if (NetRentalRevenueTotal.rawValue != 0) {

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

} else {

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

}

Highlighted

Rosie_Courtney

09-01-2012

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?

Highlighted

paulk07

09-01-2012

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