Skip to Content
0
Sep 18, 2018 at 11:41 AM

End Running Sum by Date

51 Views Last edit Sep 18, 2018 at 11:55 AM 4 rev

Hello All,

I'm looking for a solution to an issue I'm having with Running Sum on SAP BusinessObjects BI Platform 4.2 Support Pack 4, Version: 14.2.4.2410. As per below, I am trying to cut off the data as of end of month August, FY19. Anyone have any suggestions on how I may be able to do so?

Currently I'm using the following variable (the [Volume Impact + 0 (Affected)] is a variable created so that if the July values are 0, it will show a starting point on the graph.):

And when I try to add a cut off date, I get the following:

Using the following modification to the variable:

Any suggestions are very much appreciated!

Thank you!

Bhaven

Attachments

running-sum.png (32.7 kB)
running-sum-2.png (34.3 kB)
running-sum-2.png (30.6 kB)
running-sum-4.png (24.7 kB)
running-sum-3.png (34.8 kB)