Multiprovider formula help required.

[Former Member]

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,

Regards,

Archana

[Former Member]

Hello Archana,

create a formula with the following formula

(sales Qty > 0)0+(Not(sales Qty > 0))sales Qty

Now write a condition on this formula , that is formula not equal to Zero.

Hope it is helpfull

Thanks

Tulsi

[Former Member]

Hi,

Thank u for the reply .

I tried with the solution but when i add a filter in the analyser after the locaton column the total changes .

Why is it so?

Please help

its very urgent.

Regards

Archana

[Former Member]

Hi ,

Check whether have u restricted on characteristic which you are filtering.

Thanks

Tulsi

[Former Member]

but the user can have any sequence he wants in the analyser.........so i did not restrict it as the values change ...........

please help.

Regards,

Archana

[ChandranGanesan]

Hello Archana,

Create a Restricted key figure(RKF) on Sales Value based on the Location (E.g - NOSALES) , then create a formula checking in NOSALES = 0 , then display the qty

(NOSALES <= 0)(SALESQTY)(If you want to show some other keyfigure this is else part)

See this link to know about how to use [Boolean Operators|http://help.sap.com/saphelp_nw04s/helpdata/en/23/17f13a2f160f28e10000000a114084/content.htm]

Thanks

Chandran

[Former Member]

Hi Chandran,

I had tried the solution given by you previously.........but it doesn't work...........

please help it ...

Regards,

Archana