1 Reply Latest reply on Sep 4, 2018 4:11 AM by Tim Dines

    Date Calculation Logic

    DK G

      Please tell me how to achieve the below logic in calculation.

       

      Requirement 1:

       

      I have to show the Current Fiscal year data (APR’18 to MAR’19)  in Line chart.

       

      Our Fiscal year is (APR to MAR)

       

      Logic for the Line chart is

       

      (MAR’18 + APR’18)/2   for  APR’18

      (MAR’18+MAY’18)/2    for  MAY’18

       

      Same like above logic data should flow for following months.

       

      Requirement 2:

       

      I have to show the last 3 Fiscal year data in BAR chart.

       

      Our Fiscal year is (APR to MAR).

       

      Logic for the Bar chart is

       

      If FY’18 = (MAR’18 +MAR’17)/2

          FY’17 = (MAR’17+ MAR’16)/2

          FY’16 = (MAR’16+MAR’15)/2

       

       

      Regards,

      DK G