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?