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!

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!