2. CAPITAL Office Business Software
  3. Developer & Power User Support
  4. Scripting & Customisation
  5. Divide by zero error on formula
Post Reply
Topic tools
2 posts Page 1 of 1
Divide by zero error on formula
  • Nev Williams
    Divide by zero error on formula

    by Nev Williams » 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
  • COBS Tech Support
    Posts:683
    Joined:Fri Sep 09, 2005 8:23 am

    by COBS Tech Support » Thu Dec 08, 2005 11:02 am

    Use this syntax:

    IIF(Stock->Volume = 0, 0, 1 / Stock->Volume)
Post Reply
Topic tools
2 posts Page 1 of 1

Who is online

Users browsing this forum: No registered users and 8 guests

  2. CAPITAL Office Business Software
  3. Developer & Power User Support
  4. Scripting & Customisation
  5. Divide by zero error on formula
Jump to