Divide by zero error on formula
Posted: Thu Dec 08, 2005 10:39 am
I often get a divide by zero error using this formula because the Volume field is often zero. How can I prevent this?
1 / Stock->Volume
1 / Stock->Volume
Use this syntax:
IIF(Stock->Volume = 0, 0, 1 / Stock->Volume)