Skip to main content
Question

Divide a number by duration field

  • March 11, 2020
  • 0 replies
  • 64 views
  • Del
  • Quickbase Alumni
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • March 11, 2020
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement