8/18/2025 7:27:47 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
Division by Zero
Posted: 02 Apr 07 6:00 AM
|
fiogf49gjkf0d I am using Crystal v8.5 and get the following message when I run my report: 'Division by Zero', my data does consist of some 0 values. I am using the following formula:
{#CountFamily}/{#CountFamily%Conversion} *100
|
|
|
|
Re: Division by Zero
Posted: 02 Apr 07 11:58 AM
|
The data may not consist of a zero, but you're using the CountFamily as a percent of Conversion, this is likely resulting in a zero for some data and then causing the division by zero.
Maybe try this instead (very rusty on Crystal syntax so this may or may not be right  )
if ({#CountFamily%Conversion} > 0)
then {#CountFamily}/{#CountFamily%Conversion} *100
else 0
(or something like that)
-Ryan |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|