So in the first white box underneath the red boxes should be (1323 / 8201) = 16% and the other one should be (1 / 351) = 0.28%.

Thanks

Yes sorry I was being really stupid. Makes complete sense.

Thanks everyone.

iif(Sum(Fields!DNA.Value / Fields!Total.Value) > 0.1,"Red","LimeGreen") is not a valid color.

I think there is something wrong with the syntax

Thank you very much for your help.

That's not working for me as it brings back 25k rows when in my test it should only bring back 22 rows.

I think its me being really bad at explaining.

So...

So to make it clear I want to query the main table based on the temp table I have created to show more detail.

Thanks for the help. Both solutions worked.

Thank you very much GilaMonster! It worked perfectly.

I have been able to manage this with a workaround.

Basically the user clicks the icon that actions a go to URL. This then launches an aspx webpage that inserts...

I have worked it out using Client Statistics.

Thanks anyway.

Hi David,

I have added that extra where clause. I agree with what you are saying but it still come back with an error.

Msg 8114, Level 16, State 5, Line 1

Error...

Hi ChrisM@Work.

I am still getting the error

Msg 8114, Level 16, State 5, Line 1

Error converting data type varchar to float.

The data in A.Value is a VARCHAR and contains Y, 100%,...

I have got the attached outcome I expected with the following code. I was just wondering if it could be more dynamic?

-- Greater than '>' thresholds.

SELECT

M.[Description]

,A.*

,M.Threshold

,M.[Threshold Direction]

,CASE

WHEN ...

I have been able to get around it with a UNION ALL.

Can anyone think of any other way?

No because this will only bring back 3 measures. I want all of the measures to come back but only the 3 I have mentioned to calculate the case when...