It does work, apologies, I was adding the wrong values!!! They were very similar fields!!! Spent an hour looking at it and it was something so simple arrgggh!!

Excellent, it worked but is displaying an incorrect value.

When I enter the following code into the syntax, the red line is displayed under the code

=Sum(IIf(Fields!Factory.Value [highlight=#ffff11]<[/highlight]> "ABC", Fields!Total_Progs.Value,0))/Sum(IIf(Fields!Factory.Value <> "ABC", Fields!Anotherfield.Value,0))

When I run the report I receive the...

I don't want to run the package from the Server I want to be able to run it from my PC.

I thought I explained it fine, but here goes again

I am trying to run an SSIS package an install it on a file system - here are the steps I'm...

Thanks SwePeso - please could you give an example as it doesn't seem to be working for me.

I've seen your answer but can you explain your answer please?

SELECT Field1 AS [@AttributeNameHere]

Can you elaborate on this?