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
