Year to Date formula

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.

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.