Jul 24, 2019 02:53 PM
I would like to utilize a formula to calculate pricing that is contained within Single Select text.
One of my fields includes a Single Select drop down like this:
Heading: {Initial Program Cost}
325 for Massage (first 3 hours)
The next field includes a Single Select drop down like this:
Heading: {Additional Hourly Cost}
125 for Massage (each additional hour)
The next field includes a number:
Heading: {Additional Hours}
3
**I am looking for a formula that would calculate the total cost:
{Initial Program Cost} + {Additional Hourly Cost}*{Additional Hours}
325+375
I would appreciate any help!!!
Jul 24, 2019 03:16 PM
LEFT({Initial Program Cost},'FIND(' ',{Initial Program Cost})-1')+LEFT({Additional Hourly Cost},'FIND(' ',{Additional Hourly Cost})-1')*{Additional Hours}
Jul 24, 2019 05:36 PM
Thank you! I tried this, based off of what you wrote, and it worked! Amazing!
(VALUE(LEFT({Initial Program Cost},FIND(" “,{Initial Program Cost})-1)))+((VALUE(LEFT({Additional Hourly Cost},FIND(” ",{Additional Hourly Cost})-1)))*{Additional Hours})