I have created an extremely basic Info Workplace(Jacana) Subset in order
to print out price books from MAPICS.  I linked the Base Price File with
the Page 5 Pricing file and created a report with qty columns going
across in the hopes to have one line entry per Item Number per Price
Book.  I got all of the math done to calculate the Qty prices correctly,
but I cannot seem to be able to figure out a way to get rid of the
"Stair Stepping"  See below...
 
PBook Item Number Class Qty 1 Qty 10 Qty 25 Qty 50 Qty 100 Qty 250 Qty
500 Qty 1000 Qty 2500 Qty 5000
OEM     8100006     2      360.713       0         0         0
0         0         0         0             0         0
OEM     8100006     2         0      354.942       0         0
0         0         0         0             0         0
OEM     8100006     2         0              0 346.285        0
0         0         0         0             0         0
OEM     8100006     2         0              0         0  331.856
0         0         0         0             0         0
OEM     8100006     2         0              0         0          0
317.428          0         0         0             0         0
OEM     8100006     2         0              0         0          0
0 302.999        0        0             0         0
OEM     8100006     2         0              0         0          0
0         0 274.142       0             0         0
OEM     8100006     2         0              0         0          0
0         0         0 259.713           0         0
OEM     8100006     2         0              0         0          0
0         0         0         0 251.056 0
OEM     8100006     2         0              0         0          0
0         0         0         0              0 245.285

 
Lloyd H. Degnon
I.S. Manager
AmPro Computers, Inc.
5215 Hellyer Ave.
Building #110
San Jose, CA 95138
(408) 360-4365
ldegnon@xxxxxxxxx <mailto:ldegnon@xxxxxxxxx>  
www.AmPro.com <http://www.ampro.com/>  

 

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.