calculated field doesn't show the correct data

A

Alex

I have 3 fields in a query and in a report: Aug, FAug, and AugP.
In the query AugP is being calculated as follows:
=IIf(nz([FAug])<>0,nz([Aug])/nz([FAug]),IIf(nz([Aug])>0,1,0)).
So, if Aug > 0 and FAug = 0 or Null it should be 1 (or 100%).
The query shows it correctly as 1. But, in the report it appears as 0 (0.00%).
Even when I copy this formula in the report AugP field it's 0 anyway.

Could anybody advise anything about how to fix it?

Thanks
 
A

Alex

Some additional info:
When I change the format for the AugP to the General number it appears
correctly as 1 (in case of Aug>0 and FAug =0).
 
R

Rick B

I could be off here, but it does not look like you used the Nz function
properly. You do not tell it what to substitte for a null value...

nz([FAug],????)

???? should contain your substitute value.


Does is assume "0" if you leave out that argument?

Rick B



Alex said:
Some additional info:
When I change the format for the AugP to the General number it appears
correctly as 1 (in case of Aug>0 and FAug =0).

Alex said:
I have 3 fields in a query and in a report: Aug, FAug, and AugP.
In the query AugP is being calculated as follows:
=IIf(nz([FAug])<>0,nz([Aug])/nz([FAug]),IIf(nz([Aug])>0,1,0)).
So, if Aug > 0 and FAug = 0 or Null it should be 1 (or 100%).
The query shows it correctly as 1. But, in the report it appears as 0 (0.00%).
Even when I copy this formula in the report AugP field it's 0 anyway.

Could anybody advise anything about how to fix it?

Thanks
Click to expand...
Click to expand...
 
A

Alex

Thanks everybody. It's done.
The miracle was that the textbox for this field was too small and the first
number didn't appear.

Alex said:
Some additional info:
When I change the format for the AugP to the General number it appears
correctly as 1 (in case of Aug>0 and FAug =0).

Alex said:
I have 3 fields in a query and in a report: Aug, FAug, and AugP.
In the query AugP is being calculated as follows:
=IIf(nz([FAug])<>0,nz([Aug])/nz([FAug]),IIf(nz([Aug])>0,1,0)).
So, if Aug > 0 and FAug = 0 or Null it should be 1 (or 100%).
The query shows it correctly as 1. But, in the report it appears as 0 (0.00%).
Even when I copy this formula in the report AugP field it's 0 anyway.

Could anybody advise anything about how to fix it?

Thanks
Click to expand...
Click to expand...
 
Top