7 Replies Latest reply: Jul 22, 2015 7:59 PM by Sunny Talwar RSS

    SUM Criteria

      Hi All, I have made a similar question before, but I don't know if this apply as the one before.

       

      example data attached.

       

      my question is about this formula:

       

      SUM({<[Fiscal Year]={'$(=Year(TODAY()))'}>}[Netsales])

       

      What I understand this is: Sum all Netsales that criteria for [Fiscal Year] is today's year is 2015. out Fiscal Year end on sept 30th, but if today were Oct 1st, 2015, that formula will still show year 2015.

       

      so now, within the date table, I have Date field that can match the Fiscal Year field.

       

      How can I do this?

       

      Thanks