We do this with one of our apps and use a the minutes from zero i.e. midnight. You can set up a function or a lookup table to off set...

That's a a thought I could try to twist the data the other way. After a long time staring at the same data/reports I've gone blind to other avenues.

Many thanks.

Mart

Hi Matt,

Thanks for coming back to me. Yes I have tried;

=(sum(fields!week1.value,"GroupC")/sum(fields!week1.value,"GroupB"))

But the value I need is from the same group. May be previous would be the way to go....

The problem is I need to referrer to a line within the same grouping.

The data is headcount data from the result of a pivot from which I get 5 data...

Hi,

The data is from an sql table stored at the lowest level but the % value I need must be produced in the report as it is used at various...