5 Replies Latest reply: May 23, 2016 1:32 AM by Kshitija Shinde RSS

    Fiscal Year Comparison

      Hopefully someone can help or point me in the right direction
      I have the script

      SUM ({$<[Fiscal Year]={$(=only([Fiscal Year])) }>}Amount)

      This seems to work fine for a calendar year but my fiscal year is 1st August - 31 June
      Is there a way that if a user selects these the dates then the correct data will be shown
      2009 / 2010 would show turnover from 01 aug 2009 - 31 Jul 2010
      2010 / 2011 would show turnover from 01 aug 2010 - 31 Jul 2011
      I've created a fiscal calendar but the script doesn't seem to like it over a two year period
      Thank you in advance