locked
matrix problem with group column RRS feed

  • Question

  • I have a matrix which needs to look like the following:

    system   current     2005-08   
                     target    downtime    2005-08    2005-07   2005-06   2005-05

    bedd88    100%       320            99.97%      99.99%   100%      99.98%

    the downtime is calculated by this expression which is causing a problem which causes the matrix to look like this (notice there are 2 rows for system bedd88 which is what I dont want)

    system   current   2005-08   
                    target    downtime     2005-08     2005-07  2005-06     2005-05

    bedd88    100%       320           99.97%        0.0%         0.0%           0.0%
                                           0                0.0%    99.99%   100.00%      99.98%

    bexf66      100%           0                0.0%       99.99%    98.00%      98.98%
    bezg77       99%           0                0.0%       95.99%    97.99%     100.00%

    the problem is this:  downtime is only to be calculated for the current month and otherwise should display a zero in this column if there is no data for the current month so I have a calculated field in the dataset called downtime minutes that is used for this column

    =iif(Fields!START_LCL_DT.Value = Fields!MAXDT.Value , (((100.0 - Fields!PERCENT.Value )/100) * Fields!VALUE_CNT.Value )/60,0)

    because the matrix considers this a "group by" field ... it is creating one row for when the start_lcl_dt = MAXDT    and another  row for when start_lcl_dt <> MAXDT and that is not what I want to do!  How can I resolve this ??  The format has to look like I described so moving the downtime column is not an option.

     

     

     

    Wednesday, February 1, 2006 6:44 PM