Hmm. That really should have taken care of it.
Maybe {Part.PartsPerContainer} is null?
Change the “if†part to:
If (IsNull({Part.PartsPerContainer}) or {Part.PartsPerContainer} = 0)
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:765cd1.png@f22dc3e5.41b9596c]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com]
Sent: Wednesday, May 13, 2015 3:50 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] RE: Division by zero error
First of all thank you for your reply. I desperately needed help. I had high hopes for your suggestion especially since this is urgent and it made a lot of sense. I made the change but unfortunately I still get the same error. Is there something else I’m missing?
Patricia Hall
Systems Analyst
T: 256.978.6294
E:
phall@...<mailto:
phall@...>
www.cbcings.com
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com]
Sent: Wednesday, May 13, 2015 2:30 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] RE: Division by zero error
The problem is likely that Part.PartsPerContainer equals zero for one of the parts.
Because you cannot divide by zero, you want to do something like:
If ({Part.PartsPerContainer} = 0) then
0
Else
{orderrel.Calc_RelQty}/{Part.PartsPerContainer}
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@...<mailto:
jrojas@...> | www.matsinc.com<
http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring
[cid:376ca1.png@58f2cb6a.4eaf94a5]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From:
vantage@yahoogroups.com<mailto:
vantage@yahoogroups.com> [mailto:
vantage@yahoogroups.com]
Sent: Wednesday, May 13, 2015 3:24 PM
To:
vantage@yahoogroups.com<mailto:
vantage@yahoogroups.com>
Subject: [Vantage] Division by zero error
Good afternoon all,
I’m trying to add a calculated field to the SO Pick List but I’m getting a division by zero error.
I added the Part table to the SOPickList RDD, created a relationship on Company and PartNum. Added a calculated field called TotReq to the Part table in the RDD (not sure I needed this but I added it anyway.)
Added this formula OrderRel.Calc_RelQty / Part.PartsPerContainer inside the SOPickL report in Crystal Reports.
When I try to run the SO Pick List Report I get the following error:
Division by zero.
Details: errorKind
Error in File tmp2 {04091A14-484C-4FD3-81EE-7541431A017E}.rpt:
Error in formula TotesReq:
‘{orderrel.Calc_RelQty}/{Part.PartsPerContainer}’
Division by zero.
Details: errorKind
Any help would be greatly appreciated.
I’m running 905.702A, Crystal Reports, SQL database
Patricia Hall
Systems Analyst
T: 256.978.6294
E:
phall@...<mailto:
phall@...<mailto:
phall@...%3cmailto:
phall@...>>
www.cbcings.com<
http://www.cbcings.com>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]