Hi,

Thanks in advance for any help.

I have an expression of the following on a cell. Basically if WK_NO is less than 3 then do the calc else place a 0/Nothing

=IIF(Fields!WK_NO.Value<=Parameters!OMP_Option.Value, SUM(Fields!AMOUNT.Value/52.14) - Fields!SMP_AMT.Value , Nothing)

The data is of type:-

WK_NO VALUE

1 5

2 5

3 5

4 0

5 0

I would like a total of 15 showing but the expression above visibly returning 0/Nothing but it is still assuming for WK_NO 4 and 5 there is '5' so is giving me a total of 25.

I tried SUM(ReportItems.textbox10.value) to try and get round this but i get the aggregate error.

I just want to be able to SUM the values of what is visible in the output.

Thanks