9 Replies Latest reply on Oct 30, 2013 9:36 AM by Philip Keogh

    How can I get the count of years in my data?

    Sami Rayes



      My source has sales over time. I am interested in getting the yearly sales average by dividing the sum of sales over the number of years (I know my data spans over 5 years).


      When I tried to use Count([dateOfSale]), I got 651 - not sure what to use to get the number of years. I searched, but did not find anything relevant.


      Thank you in advance.