Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Running totals

Hi,

For the atached Data please help me with the Running total in a Calcualted Column.

 

Can we apply Running totals (Calcualted Column) to an existing  Calcualted Column in the dataSet.?

 

Regards,

https://drive.google.com/file/d/18gOG1b4VIlnQyg-c-xXQf9K7VcsPrCO2/view?usp=sharing

Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi All,

     

    Sorry if am wrong but i could manage to get the result as with Earlier Function.

     

    Thank you all for your time.

     

5 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi,

    What is the logic of the numbers in the Required result column?  Why does the cell link change in cell E7?  Describe the question in detail.  Describe the business logic.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello Ashish,

      I'll make clear about my requirement. wish to roll the numbers till the end of financial Year and get the result.

      Example: I 've a REvenue figure ($500) expected in August'19 (Monthly Recurring) should be added to the revenue till FY 20 (Till Mar'20) . Hence, $500* 8 = $4000 and this should be added to my total forecasted Revenue. 

      Please help me with the request.'ve below data sets.

       

      1. Datasets with revenue figures month 

      2. Master Calender data set with month as primary Column between both.

       

      Please advise the logic we can roll the numbers till the end of financial year from the time month it is expected.

       

      Please let me know if you need further details.

       

      Regards,

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        7 years ago

        Hi,

        I have read your question over and over again.  I just cannot understand.  May be someone else will help you.