Recent error - 1.#Je+000 - when summing a group

[Former Member]

Ok...so maybe it isn't an error, but when summing perfectly reasonable values I get this as the output

1.#Je+000

This is just a recent occurance as the reports have been returning normal values previously.

Database or Application problem?

Crystal XI

Edited by: jcarroll01 on Dec 17, 2010 3:39 PM

[Former Member]

Ok...sorry for the confusion...

Here is where the error actually occurs

Field1 = 656

Field2 = 461,552

When creating this formula - If Field1 = 0 then 0 else Field2 / Field1

The formula returns a correct value on some rows, but returns the 1.#Je+000 result on others

This row returns the actual answer

Field1 = 681

Field2 = 494,639

Returns 754.76

[Former Member]

How odd. Did you check to be sure all the data in the fields is numeric?

if isnumeric(field1) and isnumeric(field2) 
then
  If Field1 = 0 then 0 else Field2 / Field1
else 
0  // or put a large strange number here to test, like 99999

[Former Member]

Some additional info.

- Def. number formatted data fields since some of the summaries return data

- Related, some way, to conditionally suppressing the section.

I wish I could post a jpg of the output or something, it's really strange.

This isn't isolated to a single report either, so I probably should move this to another forum.

Edited by: jcarroll01 on Dec 21, 2010 11:03 PM