Divide a number by duration field
I have a simple formula numeric field that i want to calculate ; formula below. The days in this invoice is a formula duration, getting error "Operator cant be applied on types number duration" [...
Forum Discussion
Try this
[Total]/ToDays([Days in this invoice])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
[Total]/ToDays([Days in this invoice])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark,
What if your duration field fluctuates duration... Like some records are Hours but some are Days.
I have a formula duration that calculates the amount of time between 2 date/time fields. Then I want to take that and multiply it by a currency.
4 days * 100
4 mins * 100
------------------------------
Amber Polston
------------------------------
What if your duration field fluctuates duration... Like some records are Hours but some are Days.
I have a formula duration that calculates the amount of time between 2 date/time fields. Then I want to take that and multiply it by a currency.
4 days * 100
4 mins * 100
------------------------------
Amber Polston
------------------------------
- If your rate is say 100 per 24 day, then you would convert to hours and then multiply.
Like
ToHours([my duration field]) * 100
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- sorry correction
ToHours([my duration field]) * .. times whatever your Hourly rate is.
or else
ToDays([my duration field]) * .. times whatever your Daily rate is.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
