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 4thank you