Many thanks,

I have been playing with this for a little this morning and have changed it so that if [Measures].[R] = 0 THEN [Measures].[R]

Not happy with that but it does the trick for removing the rows that should be NULLS. Just having a look at the IIF statement link.

Thanks

E