12 Replies Latest reply on Jan 23, 2018 7:25 PM by Shinichiro Murakami

    Month and Quarter Calculations?

    Samanth Yadav

      Hi All,

       

      I'm stuck up at month and quarter calculations. I have data where i have information about the date and value fields. The data gets loaded once every month.

       

      For example:

      Date                        Value

      2017-1-31               10000

      2017-2-28               10100

      2017-3-31               10200

      2017-4-30               10300

      2017-5-31               10400

      2017-6-30               10500

       

      The value here acts as the ending value. So here the Jan month value becomes the beginning value of Feb month and the value 10100 for the Feb month from the database is the ending value. So here I need a month calculation, where if a user selects the Feb 2017 month they should see 10000 as the beginning value (which is the ending value of Jan 2017)  and 10100 as the ending value. Similarly, when they select the Feb 2017 month they should see 10100 as the beginning value (which is the ending value of Feb 2017)  and 10200 as the ending value.

       

      For Quarter Calculation, lets say if it is 1st quarter of 2017, then we should see the beginning balance as of Jan 2017 and ending balance as of March 2017

      And if it is 2nd quarter of 2017, then we should see the beginning balance as of Apr 2017 and ending balance as of June 2017.

       

      Also attached the sample excel file for reference.

       

      Thank you.