Dave Stone
asked on
Crystal Reports - Divide by Zero
Hello,
I have a very simple formula that is giving me a divide by zero error. The formula is:
{tcsfg.itotval} / {tcsfg.iqty}
So I added a test for the divisor:
If
{tcsfg.iqty}= 0
then
0 else
{@UNIT_VALUE}
The Formula UNIT_VALUE = {tcsfg.itotval} / {tcsfg.iqty}
It then tells me that “A formula cannot refer to itself either directly or indirectly.”
Any help with this would be appreciated.
Thank you
I have a very simple formula that is giving me a divide by zero error. The formula is:
{tcsfg.itotval} / {tcsfg.iqty}
So I added a test for the divisor:
If
{tcsfg.iqty}= 0
then
0 else
{@UNIT_VALUE}
The Formula UNIT_VALUE = {tcsfg.itotval} / {tcsfg.iqty}
It then tells me that “A formula cannot refer to itself either directly or indirectly.”
Any help with this would be appreciated.
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER