Forum Discussion

karimk's avatar
karimk
Icon for Helper III rankHelper III
8 years ago
Solved

Monthly Cumulative Result Not Working

Hi everyone. I´m having a problem getting the correct result with a measure for cumulative monthly results. My goal: get monthly cumulative values on a line chart for my "rent / square meter" cost....
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may download my solution from here.

     

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

You may download my solution from here.

 

Hope this helps.

  • karimk's avatar
    karimk
    Icon for Helper III rankHelper III
    8 years ago

    Thank you very much!

    If I have a chart that spans 2 or more years, the DATESYTD formula will only calculate the cumulative value within each year? If yes, what should I do when I want the monthly cumulative value starting on the first and ending on the last years selected?

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

      You are welcome.  I have updated the file with a new measure which cales yield since inception.