Select Expert Still Showing Zero Totals 1

[TanmedIT]

I have an AR Aging report that is supposed to not show totals are equal to zero. However I am still getting some groups that are showing when there totals are zero. Here is my group selection criteria:

Sum ({@TotalAmt}, {ARCUSFIL_SQL.cus_no}) <> 0.00 and
Sum ({@TotalAmt}, {AROPNFIL_SQL.apply_to_no}) <> 0.00

I have tried to use formulas in the Format Section menu that would suppress those rows if they are <> 0, however they still show up. If I remove the selection criteria, then I get about 10 times as many accounts with zero totals, so I know it works for some but not for others.

If I need to I can save the report with data and send it off you anyone that can help me out.

Thanks in advance,

Josh

 

[lbass]

I wonder if this is a rounding issue. Try:

round(Sum ({@TotalAmt}, {ARCUSFIL_SQL.cus_no})) <> 0 and
round(Sum ({@TotalAmt}, {AROPNFIL_SQL.apply_to_no})) <> 0

-LB

 

[TanmedIT]

Worked like a charm.. Thats so much, you just saved me a few hours of work. Now I can leave work early today.. WOOHOO!!

So how does this point system work on these forums!!

 

[TanmedIT]

I figured it out.. I sent a star for you.. Thanks again.

Would LBass stand for LargeMouth Bass? If so, if you are ever in SoCal hit me up, I will take you out on my boat for some bass fishing.. If not, disregard!!

 

[IdoMillet]

Josh,

Is this in Crystal XI? I'm inetersted because I've encountered a possibly-related issue in Crystal XI.

Cheers,
- Ido



Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[TanmedIT]

Nope, I am using 8.5

 

[IdoMillet]

Thanks.

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[dgillz]

I use Macola quite a bit (I recognized your table and field names) and I often use round() in group selection formulas.

Why this does not work without this I do not know as {@TotalAmt} would usually be AROPNFIL_SQL.Amt_1+AROPNFIL_SQL.Amt_2. Since both of these fields have a precision of 2 decimal places, I don't understand how the round() is ever needed, but I run into it regularly.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Madawc]

I had something similar when I was using 8.5. We use an SQL database, which means that calculated numeric values sometimes have lingering infinitessimals. I was needing to identify a payment that was exactly half of another payment. Without rounding, it would not agree that 3.48 was half of 6.96.

I've no idea whether this is still necessary for Crystal 10 and above.

Madawc Williams (East Anglia, UK)
Windows XP & Crystal 10