Year to Date formula

726 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I need to create a Year to Date field that calculates YTD pay, but I am unsure of the formula to use. All help is appreciated.

1 Reply 1

There isn’t enough detail in your question to answer it accurately so here’s a guess:

{Pay Rate} * DATETIME_DIFF(TODAY(), {Date Field}, 'years')

This assumes that the pay rate is an annual figure, which is why it is being multiplied by the number of years since some start date and “today”. Change “years” to “months” or “weeks” or whatever if that’s more appropriate.