3 Replies Latest reply on May 25, 2017 5:00 AM by Brawley Thomas

    Confusion on calculating number of months YTD

    Brawley Thomas

      Hello,

       

      I am having an issue with a calculated field. The goal is to have it show the number of months since January. I thought this should be a simple calculation and used this:

       

      DATEDIFF('month',#2017-01-01#, TODAY())

       

      The point is to then multiply that by our revenue from each customer to get YTD revenue per customer. Obviously I could manually type the number of months, but the goal is to have it change dynamically. The problem I'm running into is that although most rows show the correct value, a few show numbers in the thousands. I have no clue why that would be since the calculation should be the same considering it is independent of any other field.

       

      Thanks for your help,

      Brawley