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
BedrockMission!

Learn More

View all

Sign in to view all badges

percentage formulas

Avatar

Avatar
Level 1
Rosie_Courtney
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Rosie_Courtney
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile
Rosie_Courtney
Level 1

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

Avatar

Avatar
Validate 1
Level 4
paulk07
Level 4

Likes

29 likes

Total Posts

293 posts

Correct Reply

20 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 4
paulk07
Level 4

Likes

29 likes

Total Posts

293 posts

Correct Reply

20 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
paulk07
Level 4

09-01-2012

if (NetRentalRevenueTotal.rawValue != 0) {

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

} else {

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

}

Avatar

Avatar
Level 1
Rosie_Courtney
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Rosie_Courtney
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile
Rosie_Courtney
Level 1

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?

Avatar

Avatar
Level 1
Rosie_Courtney
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Rosie_Courtney
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile
Rosie_Courtney
Level 1

09-01-2012

Paul,

These totals will constantly be changing

Avatar

Avatar
Validate 1
Level 4
paulk07
Level 4

Likes

29 likes

Total Posts

293 posts

Correct Reply

20 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 4
paulk07
Level 4

Likes

29 likes

Total Posts

293 posts

Correct Reply

20 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
paulk07
Level 4

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