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.
Page 1 / 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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.