Answered by:
how do I calculate Cumulative Overage
Question
Answers

I have a report and used the following expression to get overage
=Fields!nbr_created.Value  Fields!nbr_comp.Value  Fields!nbr_canc.Value
how would I write an expression calucate cumulative overage from month to month?
Hi,
Is this what you need ?
then try this expression :
=RunningValue((Fields!Created.ValueFields!Completed.ValueFields!Cancelled.Value), Sum, Nothing)
If you had calculated the Overage from dataset itself then the expression can be like this :
=RunningValue(Fields!Overage.Value, Sum, Nothing)
sathya  Mark as answered if my post solved your problem and Vote as helpful if my post was useful.
 Proposed as answer by Uri DimantMVP Sunday, June 16, 2013 7:45 AM
 Marked as answer by Elvis LongMicrosoft contingent staff, Moderator Monday, June 24, 2013 2:35 AM
All replies

I have a report and used the following expression to get overage
=Fields!nbr_created.Value  Fields!nbr_comp.Value  Fields!nbr_canc.Value
how would I write an expression calucate cumulative overage from month to month?
Hi,
Is this what you need ?
then try this expression :
=RunningValue((Fields!Created.ValueFields!Completed.ValueFields!Cancelled.Value), Sum, Nothing)
If you had calculated the Overage from dataset itself then the expression can be like this :
=RunningValue(Fields!Overage.Value, Sum, Nothing)
sathya  Mark as answered if my post solved your problem and Vote as helpful if my post was useful.
 Proposed as answer by Uri DimantMVP Sunday, June 16, 2013 7:45 AM
 Marked as answer by Elvis LongMicrosoft contingent staff, Moderator Monday, June 24, 2013 2:35 AM

hello Sathya, thanks, this does not look like the cumulative overage to me.
Im looking for something like the current months total created  the current months completed  the current months cancelled + the previous months overage amount = cumulative overage


I'm not being funny, but based on what you just replied with the values that Sathya has got there look perfectly fine!
You are already calcuating the Overage for each row, and what she has given you is just the cumulative values of these, which is exactly the same as what you just said it should be.

Thank you for your assistance, maybe I'm not communicating this well.
Here are what the numbers should look like
Month Created Completed Cancelled Overage Cumulative Overage 06/2013 183 92 4 87 542 05/2013 416 177 23 216 455 04/2013 342 170 35 137 239 03/2013 133 14 17 102 102