Cheers guys

I'll have aplay around to see if I can work it out...

Sorry for being stupid but do you mean like the following:

=Switch(sum(Fields!YTDBudget.Value)/sum(Fields!YTDActual.Value) -1 <-2.5, "Green", sum(Fields!YTDBudget.Value)/sum(Fields!YTDActual.Value) -1 <=-5.0, "Yellow", sum(Fields!YTDBudget.Value)/sum(Fields!YTDActual.Value) -1 <-5, "Red")

I've tried this but it seems to confuse it...

I actually want it to be below -5 (ie -6, -7 etc like you say...)

Yeah, i can write the expression directly i suppose - guess I'm being lazy!

Thanks both

Anthony

This is brilliant, thanks so much for all your help - again!

Have a great day!

Cheers Anthony!!

Ideally I'd like the report to show Monday to Friday for the weekly report but only ever show the last full working week. So if i was to run it...

Cheers Anthony

Yes, casting it as a date does the job.

Thanks for your help.

Cheers for responding so quickly...

No, there are no paramaters in the report...

Daniel

That was the problem.

Thanks for your help - much appreciated!

BO

Cheers Calvo - that's perfect for my needs.

Daniel - I could re-create the datasets as you both suggest and may end up doing so in the end but wanted to see if there was a different method...

Brilliant - works perfectly!

Thanks Martin

Cheers Andy - I'll give it a go!

Thanks again Daniel but I'm a little confused - not difficult for me!

I need to bring back the Sales value for the current month - but these are two separate...