Hi!

I have Monthly and Quarterly reports in the Payroll database. I have the calculations done for one of the field in both reports. I am trying to calculate [Fica * 2 + Federal Tax] for the monthly and quarterly. The field Fica is not acually defined the table. The calculations currently is not showing the correct results. I am attaching the database so you can see what I am talking about. You can select either Monthly or Quarterly reports for preview and look at the column for Fica*2+FedTax.

Thanks!
Neha

I don't seem to have the same issue, you are talking about the result in the textbox "txtFedTaxPlusFicaTimesTwo" correct? It works for every result I see, look at attached pdf.

Ken

Ken,

Thanks for the prompt reply.
Yes I am talking about txtFedTaxPlusFicaTimesTwo.

Ok I was confused that I am only showing Fica and not the result of Fica*2.

OOppppss!

Thanks
Neha



Neha

So did you need anymore help?

Actually yes I do.

I posted this question on different post but no one has responded yet.

I have a Payroll database and it contains Monthly report. The report seems to work fine for all the other calculated field except one of the field the report doesn't show the Sum of Gross and keep asking for parameter value for txtGross - What's wrong there? I am attaching the database. The report to review is Monthly report.

Any help provided would be helpful.

Thanks
Neha

Change the source of Text74 to =Sum([Wklyhrsworked]*[PayRate]). You can't perform aggregate functions on other controls, only fields.

HTH
Ken

Thanks Ken!

Works great now.
Thanks for the clarification on aggregate function and field controls.

Thanks
Neha

You're welcome, glad to help.