calculated field doesn't show the correct data

[Guest]

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

 

[Guest]

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).

 

[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

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).

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

 

[Guest]

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

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).

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