Summing IIF Statement Issue?

[marwan211]

I have the following statement in the details of a report.

=IIf([Text66]=0 And [Text58]=0,[atrucka royalty]*1,IIf([Text66]=0 And [Text58]=1 And [text86]=3,[atrucka royalty]*0.2,IIf([Text66]=1 And [Text58]=0,[atrucka royalty]*1,IIf([Text66]=1 And [Text58]=1,[atrucka royalty]*0.5,IIf([text86]=4,[atrucka royalty]*1)))))

How can I get it to sum in the group footer of my report?

 

[uncle-lai]

Try this:
Create an invisible textbox, set it's Data Control Source to "= (YourCalculatedField)", and it's Running Sum to "Over Group".
Set your sum text box in the Group Footer = the invisible textbox.

Peter