Hi there

I have created a number field in the detail band that uses a the formula =if(month([dateinvoiced])= 3;
if(year([dateinvoiced])= 2008;[qtyinvoiced]). This formula worked and displays the desired result. The problem I'm having is creating a number field to display the grand total of the qtyinvoiced. I have used the TotalGroupSumFunction and ItemSumFunction but it only displayed the total qtyinvoiced without the filtering condition. Even if I insert the same formula in the formula tab of the field.

Can somebody pls show me what to do?

Thanks

Jun