Discussions

Expand all | Collapse all

Formula Help-Duration Calculation

  • 1.  Formula Help-Duration Calculation

    Posted 12-05-2018 22:28
    I'm new at building formulas in Quickbase. I need to build a formula that will calculate accrued employee PTO time (it's accrued daily).
    Simply put, it would be as follows:

    (Today's Date - First Day of Current Year +1)/365*# of PTO Days Given

    # of PTO Days Given is a field in a report. I'm not sure if I need to create another field to build the formula in to get the calculation or if I just need to add a calculated field to a report.

    Any help for this novice would be greatly appreciated. Thank you in advance!


  • 2.  RE: Formula Help-Duration Calculation

    Posted 12-05-2018 22:34
    You should create a new formula numeric field called [accrued employee PTO time]

    not tested, but try this formula

    (ToDays(Today()-FirstDayOfYear(Today()))+1) / 365 * [# of PTO Days Given]



  • 3.  RE: Formula Help-Duration Calculation

    Posted 12-05-2018 22:53
    Brilliant! That worked! Thank you so much!