none
how do I calculate Cumulative Overage

    Question

  • 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?

    Friday, June 14, 2013 10:48 PM

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.Value-Fields!Completed.Value-Fields!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.

    Sunday, June 16, 2013 6:08 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.Value-Fields!Completed.Value-Fields!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.

    Sunday, June 16, 2013 6:08 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

    Friday, June 21, 2013 5:29 PM
  • Well then can you show us what the numbers *should* look like?
    Monday, June 24, 2013 1:30 AM
  • 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.

    Monday, June 24, 2013 1:46 AM
  • 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
    Monday, June 24, 2013 5:30 AM