Show zero and not error when division by zero

[SylvieB]

Hello group,
How can I show the number zero when I do a divison by zero? On my report, it
shows #Error.
I created a report that calculates the difference in percentage for the
following:
(ProposalAmount – AwardAmount)/AwardAmount)
The code on the query is
%diff[ProposalAward]-[AwardAmount])/[AwardAmount]
which works great except if AwardAmount = 0.
Any idea, how to put a zero instead of error?
Thank you all in advance for your help

 

[KARL DEWEY]

Try this --
%diff:iif([AwardAmount] Is Null, 0,
([ProposalAward]-[AwardAmount])/[AwardAmount])

 

[kc-mass]

Try This:

%diff:: IIF(AwardAmount = 0,
0,([ProposalAward]-[AwardAmount])/[AwardAmount] ))

Regards
Kevin

 

[KARL DEWEY]

Should be like this --
%diff:iif([AwardAmount] Is Null OR [AwardAmount] = 0, 0,
([ProposalAward]-[AwardAmount])/[AwardAmount])
--
Build a little, test a little.

Try this --
%diff:iif([AwardAmount] Is Null, 0,
([ProposalAward]-[AwardAmount])/[AwardAmount])

--
Build a little, test a little.

Hello group,
How can I show the number zero when I do a divison by zero? On my report, it
shows #Error.
I created a report that calculates the difference in percentage for the
following:
(ProposalAmount – AwardAmount)/AwardAmount)
The code on the query is
%diff[ProposalAward]-[AwardAmount])/[AwardAmount]
which works great except if AwardAmount = 0.
Any idea, how to put a zero instead of error?
Thank you all in advance for your help

 

[Hans Up]

Should be like this --
%diff:iif([AwardAmount] Is Null OR [AwardAmount] = 0, 0,
([ProposalAward]-[AwardAmount])/[AwardAmount])

%diff:iif(Nz([AwardAmount]) = 0, 0,
([ProposalAward]-[AwardAmount])/[AwardAmount])

 

[SylvieB]

It works great. Thank you all for your help. It is very appreciated.

Try This:

%diff:: IIF(AwardAmount = 0,
0,([ProposalAward]-[AwardAmount])/[AwardAmount] ))

Regards
Kevin

Hello group,
How can I show the number zero when I do a divison by zero? On my report,
it
shows #Error.
I created a report that calculates the difference in percentage for the
following:
(ProposalAmount - AwardAmount)/AwardAmount)
The code on the query is
%diff[ProposalAward]-[AwardAmount])/[AwardAmount]
which works great except if AwardAmount = 0.
Any idea, how to put a zero instead of error?
Thank you all in advance for your help