13 Replies Latest reply: Feb 13, 2017 5:09 AM by Rahul Pawar RSS

    Financial Year Set Analysis

    Phil Speight

      Hi

       

      I need to return data in set analysis for this financial year only (April to March). 

       

      I have a field that shows which financial Year the data is in [Financial Year].

       

      How do I create set analysis which returns a value only if we are in the current financial year.

       

      e.g.  Only sums data if today is within financial year 2016 (any data between April 2016 - March 2017)

       

      Thoughts?

       

       

      Thanks

       

       

       

      Phil