SSRS RunningValue contained within another RunningValue
<p>I have a SSRS report that shows the waste minimised/disposed by a city for a given time period. The report looks like this:</p>

<p><a href="https://i.stack.imgur.com/3AwkX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3AwkX.png" alt="enter image description here"></a></p>

<p>I am using the <code>RunningValue()</code> function to determine the 'Cumalative Quarterly' totals e.g. the cumulative quarterly total for 'Waste Generated':</p>

<pre><code>=RunningValue((Fields!WasteGenerated.Value), SUM, "WasteYear")
</code></pre>

<p>The 'Waste Diverted' is calculated with the following formula:</p>

<pre><code>=((Fields!WasteMinimised.Value / Fields!WasteGenerated.Value))
</code></pre>

<p>And the 'Quarterly Waste Diverted' is still straight forward as:</p>

<pre><code>=(Sum(Fields!WasteMinimised.Value) / Sum(Fields!WasteGenerated.Value))
</code></pre>

<p>Next I want to calculate the "Cumulative Quarterly Waste Diverted" based on the <code>RunningValue()</code> of 'Waste Minimised' and 'Waste Generated':</p>

<p><a href="https://i.stack.imgur.com/HW0kF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HW0kF.png" alt="enter image description here"></a></p>

<p><a href="https://i.stack.imgur.com/tf7RJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tf7RJ.png" alt="enter image description here"></a></p>

<p>I tried this by having nested <code>RunningValue()</code> functions:</p>

<pre><code>=RunningValue(((RunningValue((Fields!WasteMinimised.Value), SUM, "WasteYear")) / (RunningValue((Fields!WasteGenerated.Value), SUM, "WasteYear"))), SUM, "WasteYear")
</code></pre>

<p>However, with this I get the following error:</p>

<blockquote>
  <p>The Value expression for the textrun 'Textbox43.Paragraphs[0].TextRuns[0]' uses a RunningValue function in an outer aggregate. RunningValue functions cannot be specified as nested aggregates.</p>
</blockquote>

<p>I cannot think of another solution other than <code>RunningValue()</code> to complete this 'cumulative' function</p>