3 Replies Latest reply on Jul 8, 2017 5:00 PM by Hari Ankem

    Fiscal year calculation

    chandra shekhar banerjee

      Hi,

       

      I am trying to create a fiscal year calculation from a given data set.

       

      The fiscal year starts from Feb and ends on Jan. Hence, Feb, Mar, Apr are my first quarter.

       

      I am trying to create a fiscal year calculation from the date field so that I can use it for dashboard creation.

       

      My main requirement mainly Quarterly analysis.

       

      I have tried by building string  fields like 'FY2017','FY2018' as well as string quarter fields like 'Q1' ,'Q2' so that when I select parameter on the dashboard (Ex: 'Select FY','Select FQ)

      then dashboard should act upon as per the selection. But it is difficult to do date level calculation based on a string column.

       

      Hence, it would be great if anybody can help me with a calculated date column which should be as per my fiscal calendar.

       

      There are so many discussions that I found in the community but not getting a perfect one which can help me in this regard.

       

      Thanks,

      Chandra Shekhar