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

Rosie_Courtney
Level 1
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
paulk07
Level 6
Level 6

if (NetRentalRevenueTotal.rawValue != 0) {

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

} else {

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

}

Rosie_Courtney
Level 1
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?

paulk07
Level 6
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