Skip to Content
0
Former Member
Apr 13, 2014 at 08:36 AM

% Calculactions in Bex Query Designer

44 Views

Hi Experts,

Could you please on how can i perform the below % Calculactions in Bex Query Designer.

Vendor No line item Not = L category =A status =RFQ :for items

Example : I have 8 items for vendorNo 200274 and only 4 as above condition and 5 items as not L(delete)

requament: % RFQ Without Response:

Percentage of Quotation response ={(No. of RFQReponses Received/ No. of RFQ items sent)*100},

( 4/5 * 100= 80%)

Percentage RFQ without response= 100 - Percentage of Quotation response
= 100-80 = 20%

How can i perform the % Calculations in Bex Query Designer.

Vendor Purchasing document Indicator: Line Item Purch. doc. category Purch. doc. status Item Number of Records category A item L 200274 V-LINE EUROPE EXPORT MARKETING 6000003778 L A Not assigned 10 1 20 1 30 1 6000003779 Not assigned A Not assigned 40 1 9000000046 Not assigned A RFQ 10 1 1 20 1 1 30 1 1 40 1 1 Result 8 4

thank you