Post reply

Calculating Percentage in a Matrix Report

  • February 19, 2008 at 9:59 pm

    #186900

    I have a matrix report showing percentages. The percentages are calculated using the following formula:

    SUM(IIF(ISNothing(Fields!EmployeeAtPhase.Value),0,Fields!EmployeeAtPhase.Value ))/SUM(Fields!EmployeeInDepartment.Value)

    When fully expanded the report works fine as shown below:

    It is possible to collapse sections of the report as shown:

    The problem occurs where there are empty cells in the matrix. In the example the value 2.27% should have changed to 1.56%.

    Does anyone have any suggestions how I could proceed with this other than changing my stored procedure to return a 0 row for each empty cell.

    Thank you

    Fiona Kerr

  • February 19, 2008 at 10:53 pm

    #780085

    You pictures didn't show up because you didn't attach them.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • February 19, 2008 at 11:04 pm

    #780087

    Sorry,

    How do I attach them?

  • February 19, 2008 at 11:11 pm

    #780088

    Here are the pictures that are supposed to be in the original post - I hope

Viewing 4 posts - 1 through 3 (of 3 total)

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