Report Calculation Trouble

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone help me with this expression?

I have a report linked to a query with the following fields bieng pulled
from various tables:

[NRP] Currency: Non Recurring Price
[#] Number: Quantity
[TDAPP] Yes (0)/No(-1): Term Discount Applicable

In the report I have created the following calculated fields:

[TotalNRP] = [NRP]* [#]
[TDNRP] =IIf([TDAPP]="-1",[NRP]*[#],"0")

Both of which perform well. My problem is I need to total the TDNRP column
of the report.
I tried creating a new field called [TotalTDNRP] =sum
(IIf([TDAPP]="-1",[NRP]*[#],"0")) and it didn’t work.

Any help would be greatly appreciated.

Many thanks, David.
 
What do you get? Error or wrong resault?
Does this formula works when not trying to sum on it?

Any way, check the followings:
1. Yes/No fields and numbers don't need double quotes, try:
sum(IIf([TDAPP]=True,[NRP]*[#],0))

2. Check for Nulls
sum(IIf([TDAPP]=True,Nz([NRP],0)*Nz([#],0),0))

3. Make sure the text box where this formula located in doesnt have the
name: TDAPP, NRP, [#]

4. The Sum need to be on the Report Footer and not the PageFooter, it won't
work on the page footer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top