Post reply

Percentile Calculation For Running Total in a Matrix

  • November 29, 2010 at 10:35 am

    #388330

    Hi all,

    I am using SSRS 2008 Developer and am trying to calculate the percentage for two columns which are using the running total function in a matrix. Apologies in advance for the formatting!

    Here is what I have so far.....

    http://3ah79g.bay.livefilestore.com/y1pPBXTcGFzuDJtmiSfk-QhivuVqOfLwGAGDsfQQxw_BIztY4s6eAbW2Nlh18siUDMpAIameTLSVcAa7kJVsZawaZ-FJiRG2myp/Matrix.jpg?psid=1

    I need to calculate a percentage for the NILR & GILR. So far I have tried;

    NILR

    =RunningValue(SUM(Fields!INCURRED.Value),

    Sum, "ContractYear")\RunningValue(SUM(Fields!UWNET.Value), Sum, "ContractYear")*100

    GILR

    =RunningValue(SUM(Fields!INCURRED.Value),

    Sum, "ContractYear")\RunningValue(SUM(Fields!GROSS.Value), Sum, "ContractYear")*100

    Hopefully this will be enough information but please let me know if you require more.

    Any help will be appreciated.

    Regards

  • November 30, 2010 at 7:38 am

    #1256796

    I managed to do this using the INSCOPE function. For anyone else that may need to do something similar, I used the following expression in the NILR field and changed the text properties to percentage;

    =IIF(InScope("ContractYear") And InScope("DevelopmentQuarterDesc"), RunningValue(Fields!INCURRED.Value, Sum, "ContractYear")/RunningValue(Fields!UWNET.Value, Sum, "ContractYear"),0)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply