Skip to main content

Year to Date formula

  • October 18, 2021
  • 1 reply
  • 18 views
T

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.

    This topic has been closed for replies.

    1 reply

    Kamille_Parks11
    Forum|alt.badge.img+27

    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.

      Terms & ConditionsAccessibility statement