Skip to Content
Former Member
May 27, 2008 at 12:37 PM

Multiprovider formula help required.


Hi Gurus,

I have prepared a query on MP which contains two infoproviders stocks and the other sales.

I prepared a quer whose output is as follows

Location Sales Tonnes Contribution Sales Value QTY

Lagos 11122222.00 12345.00 111111190.00 2500

Port haccort 1200

Warri 56712345.00 121324 347678734.00 4000

this is the result and it matches the values also.

I want to design another query from the same MP which will have a column No sale qty. This column will display the qty which is having no sales as in the above case for Port Haccort.

please suggest to do.

Points will be awarded

Thanx in advance,