Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

percentage formulas

Avatar

Level 1

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

4 Replies

Avatar

Level 6

if (NetRentalRevenueTotal.rawValue != 0) {

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

} else {

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

}

Avatar

Level 1

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?

Avatar

Level 6

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