thanks to all of you. you all pushed me in the right direction

thanks again

thanks for your help

unfortunately, totalmoney needs to be a Sum, as it is the totalmoney earned in a time period & SSRS will not allow me to have a Calculated dataset with a...

you are correct have you any idea of an expression that would sum only the result of the NI?

I apologise, yes it is an SSRS problem. I will post there also. The problem I have is that the expression I am using is giving me, a...

thanks for your help. Unfortunately, I need to "sum(field!totalmoney.value)" & ssrs will not allow me to sum within a sum expression.