Divide a number by duration field

Question

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"

[Total]/[Days in this invoice]

------------------------------
Ermias Bean
------------------------------

MarkShnierYou · Answer

Try this[Total]/ToDays([Days in this invoice])------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community