Problem with sub-total breaks on a report
GCC Consulting
gccconsulting at comcast.net
Wed Apr 15 07:28:42 PDT 2009
> -----Original Message-----
> From: filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com
>
[mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com]
On
> Behalf Of Boaz Bezborodko
> Sent: Tuesday, April 14, 2009 12:45 PM
> To: Kenneth Brody
> Cc: filepro-list at lists.celestial.com
> Subject: Re: Problem with sub-total breaks on a report
>
>
>
> Kenneth Brody wrote:
> > Boaz Bezborodko wrote:
> > [...]
> >> 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.
> >
> > Can you give us an actual example?
> >
> > [...]
> >> 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?
> >
> > You have an error on line 42.
> >
> > http://www.google.com/search?q=wikipedia+"error+on+line+42"
> >
> When going through the data before hitting any of the breaks cl="".
> Once the first break point is hit it should equal '0' until given the
> value of ch which in my sample data is "62.32". But it only shows this
> when in the @wbrk routine. Once it starts going through the data lines
> again cl shows up as '/d0'. When it gets to @wbrk2 again it shows as
> "62.32" until a new ch gets added, in this case a value of '248.73' and
> 'cl' then correctly shows a value of '311.05'. At that point it hits
> @wbrk3 and the value shows '396.49' for no particular reason that I can
> find. There is no '396.49' anywhere in the data set I'm working with.
>
> I did find that I could get 'cl' to hold the right data if I put it in
> AUTO processing. But I'm trying to find out what FP is doing otherwise.
My usual solution to handling this type of calculation is to use an array to
hold the totals which total for each detail line. Since some of my
application can have up to 6 commission splits on any one detail line and
each of these are a percentage of the whole commission due, I have found
this the easiest way to handle.
You can use each element of the array to hold the value needed at each break
point. Just remember to clear that element, if necessary.
Also, since you seem to be getting a divide zero error, I would test ca gt
"0" before doing this calculation,
Richard Kreiss
GCC Consulting
rkreiss at gccconsulting.net
More information about the Filepro-list
mailing list