Sum function not working in Report group footer

[aguirrema]

The following does not work in the report group footer. It calculates
the data for the whole report. Any suggestions?

=IIf([Contract Value]<500000,(Sum([K Fee])/Sum([K Cost])),0)

Thanks,
Maria

 

[Jeff Boyce]

Have you tried doing that calculation in the underlying query you use to
feed the report?

Can you give us a bit more description about what data is in the
fields/controls?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

If you want to calculate the Fee to Cost ratio for all contracts over 50000 then
you need to do something like the following. Sum all the Fees with a contract
value over 50000, then do the same for cost and finally do the division.

=Sum(IIF([Contract Value]>50000,[K Fee],Null)) / SUM(IIF([Contract
Value]>50000,[K Cost],Null))

 

[aguirrema]

Thanks John - that worked!

If you want to calculate the Fee to Cost ratio for all contracts over 50000 then
you need to do something like the following. Sum all the Fees with a contract
value over 50000, then do the same for cost and finally do the division.

=Sum(IIF([Contract Value]>50000,[K Fee],Null)) / SUM(IIF([Contract
Value]>50000,[K Cost],Null))

The following does not work in the report group footer. It calculates
the data for the whole report. Any suggestions?

=IIf([Contract Value]<500000,(Sum([K Fee])/Sum([K Cost])),0)

Thanks,
Maria