Earnings calculator | Community
Skip to main content
Answered

Earnings calculator

  • February 15, 2023
  • 5 replies
  • 128 views

Needing to create an earnings calculator for potential customers and I am having some trouble figuring out exactly how to go about it. We are a medical device manufacturer, so we sell to physicians and med spas, and we are wanting to create a potential earnings calculator, that can show them their estimated monthly revenue if they were to purchase our device.

The formula is simple: (# of treatments per day) x (# of working days per month) x (price per treatment) = estimated monthly revenue.

We have need to have this formula applied to three different treatment options, and they select how many of those treatments offerings they will be offering. If it is multiple treatment options, we need this formula applied to each, and then added together for the total amount at the end. If this makes sense?

Pricing and number of treatments offered differs for every practice. How can I make this a calculator to give them their “estimated monthly earnings” at the end of the quiz?

 

Any help greatly appreciated!

Best answer by Liz

Hi @thermiteam Thanks for stopping by the community! 😀 Are you asking all of those questions in the formula within the form? If so, I think you might have a relatively similar setup in terms of calculation to this post below (depending on how you ask the questions): 

 

View original

5 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14950 replies
  • Answer
  • February 16, 2023

Hi @thermiteam Thanks for stopping by the community! 😀 Are you asking all of those questions in the formula within the form? If so, I think you might have a relatively similar setup in terms of calculation to this post below (depending on how you ask the questions): 

 


  • Author
  • Explorer
  • 1 reply
  • March 3, 2023

Hi Liz,

Thank you for your help. The problem I am running into right now is how to multiply three different number scores together, and then show this result at the end. I need (price per treatment) x (number of treatments per day) x (number of working days in the month) = estimated monthly earnings

For example, they input that their treatment price is $1200, they do 4 treatments a day, and they are working 20 days a month. I have honestly been trying to figure this out for hours now and can’t seem to get it all just right! I can figure out how to create variable that I can add those amounts they input to, and then can multiply TWO of those variable together, but do not know how to then multiply that result by the third variable. 

Thank you for your help!

Storm


Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14950 replies
  • March 3, 2023

Ohhh, got it, thanks, @thermiteam ! I don’t think calculating three numbers together is possible, but @john.desborough might have a fancy workaround solution for you!


etterlingd29
Forum|alt.badge.img+1

excuse me, but how exactly does this work?


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5284 replies
  • March 3, 2023

@thermiteam - create a few variables and some logic rules .. i use some ‘sample variables’ below that you would have to create (or something similar)

assumed: q1 is the price per treatment, q2 is number of treatments per day and q3 is number of days qeustion

 

logic rules

  • if q1 is gt 0 then add q1 to v_total
  • if q2 is gt 0 then multiply v_total by q2
  • if q3 is gt 0 then multply v_total by q3

that will give you the total for this medical device.. 

if you create the form with question groups to allow for different devices to be selected and similar questions, then you would need to create a series of subtotal variables instead of v_total above - ie v_device1, v_device2, etc. 

 

des


Reply