Dave Stone
asked on
Crystal Reports 9 Two Zero Fields
Hello,
I have a report that has a couple of simple formulas. One formula references a field that may be zero so I have used a formula to identify it but in that same formula there is a field that also may be zero. How do I handle that? I have attached the formula I am referring to. When I insert this formula I get a divide by zero error.
efficiency.txt
I have a report that has a couple of simple formulas. One formula references a field that may be zero so I have used a formula to identify it but in that same formula there is a field that also may be zero. How do I handle that? I have attached the formula I am referring to. When I insert this formula I get a divide by zero error.
efficiency.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect! Thank you.
if varA=0
then fix_value
else varB/varA