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.
