objects
I have a query which is returning sums of volumes, sums of prices, and
average prices. BO splits this into 2 queries which are joined on all of
the common fields (all fields except the above). I have put the sales on
one tab and the purchases on a second tab. I created a weighted average
price as a variable defined as the Total Purchase Dollars / Total
Purchase Volume, which are defined as sums in the second tab. I want to
subtract this variable (Weighted Average Price) from each Sales price on
the first tab to get a margin for each row.
When I attempt to do this, I get #IERR in each margin column.
Thanks for any help you can give me.
I think it is a problem of context in each tab. You probably don’t have the
same context of calculation in each tab, so the results appear
disappointing.
Maybe you can describe us more in details your reports.
Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
Web archives (9am-5pm ET only): listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
====================================
Listserv Archives (BOB member since 2002-06-25)