Discussions

Expand all | Collapse all

Divide a number by duration field

  • 1.  Divide a number by duration field

    Posted 29 days ago
    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
    ------------------------------


  • 2.  RE: Divide a number by duration field

    Posted 29 days ago
    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
    ------------------------------



  • 3.  RE: Divide a number by duration field

    Posted 29 days ago
    awesome, thanks, works

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