"division by zero" error Crystal Reports XI formula 1

[Dausa67]

Good Morning,

-Goal: To determine "months of stock on hand"
-Problem: I have fields that are empty with no data or a qty of zero. That is causing me to get an error message "Division by Zero" so the report will not run

My formula: {TS.AVAILABLE} / {TS.AVG_MONTHLY_USAGE}

Does anyone have any suggestions?

Clay
"Without ambition, one starts nothing. Without work and determination, one finishes nothing. The prize will not be sent to you. You have to win it."[/b]

 

[SkipVought]

thread767-1595409

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Dausa67]

Thanks. I tried that but I am still getting the "Division by Zero" message.

Any other suggestions?

Clay
"Without ambition, one starts nothing. Without work and determination, one finishes nothing. The prize will not be sent to you. You have to win it."[/b]

 

[lbass]

Please show the content of the actual formula you tried.

-LB

 

[SkipVought]

Exactly WHAT did you try that does YET not work?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Dausa67]

if {V_TSLOOKUP.AVAILABLE} <> 0
then {V_TSLOOKUP.AVAILABLE}/{ASI_ITEM_MASTER.AVG_MONTHLY_USAGE}

Clay
"Without ambition, one starts nothing. Without work and determination, one finishes nothing. The prize will not be sent to you. You have to win it."[/b]

 

[SkipVought]

You must test the DENOMINATOR for ZERO!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}