Problem with sub-total breaks on a report
John Esak
john at valar.com
Tue Apr 14 12:20:40 PDT 2009
What you are missing is that you must first track down why you are getting
the divide-by-zero error.
John
> -----Original Message-----
> From: filepro-list-bounces+john=valar.com at lists.celestial.com
> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
> m] On Behalf Of Boaz Bezborodko
> Sent: Tuesday, April 14, 2009 11:49 AM
> To: filepro-list at lists.celestial.com
> Subject: Problem with sub-total breaks on a report
>
> I have a report that totals up sales and deductions on
> payments and then
> uses this to generate a commission percentage to apply to the invoice
> amounts generating a commission amount per customer during @wbrk2. I
> then have to total those up to get a total commission amount for each
> sales rep in @wbrk3. (@wbrk1 is on a sub-level for individual
> customer
> checks.)
>
> I use a global variable 'cl(12,,2,g)' that gets set to zero
> for each new
> sales rep. In the customer sub-totals I add the commission
> amount to cl.
> When I step through the debugger cl is correct on the customer
> sub-total, but when I look at it on the sales rep sub-total break the
> amount is not the same and I can't figure out where it came from.
>
> (During the data lines cl shows up as '/d0')
>
> In @wbrk2 I have
> ? If:
> Then: ch(10,,2)=cg*ca/"100" ; cl=cl+ch
> The very first line of code checks if it is on a new sales
> rep and, if
> so, sets cl(12,,2,g)=""
>
> What am I missing?
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
More information about the Filepro-list
mailing list