Top 5 Items in Lab Formulas After 15-Aug-2022

SELECTROW_NUMBER() OVER (PARTITION BY O.orders_id ORDER BY O.orders_id, OP.tktSPAmount DESC) [Rank], OP.orders_products_id ID,O.date_purchased [DocDate], O.usps_track_num2 [Formula Drive By], REPLACE(REPLACE(O.remarks, CHAR(13), ”), CHAR(10), ”) [Remarks], REPLACE(REPLACE(O.terms, CHAR(13), ”), CHAR(10), ”) [Sample Text], REPLACE(REPLACE(O.[days], CHAR(13), ”), CHAR(10), ”) [Boxcode], O.documentTextId DocumentId,OP.products_id ItemID, OP.tktSPAmount RequiredQuantity, hotelArrivalBy FilledQuantity, hotelDateTimeTo FilledOnFROM orders OLEFT JOIN orders_products OP ON O.orders_id = OP.orders_idWHERE […]

Read More

SearchReview QTY CALCULATION

SearchReview 1) SearchReview FidAmount is calculated by its own method 2) Then we sum FidAmount molecule-wise for Molecule Total_FAmount 1) For Suggested quantity, difference is calculated with following formula total_diff = (1-([LabQty]/Total_FAmount))*100 2) [Sug_Total_Avg] = Total_FAmount * (1 – (AvgTotalDiff / 100)) AvgTotalDiff is average of difference of all difference percentages ranges between +-100 Irfan […]

Read More

 YSEARCH QTY CALCULATION

 YSEARCH 1) First we calculate FID Quantity FidQty = (FIDAREA * PARAMETERQTY) / PARAMETERAREA 2) Second we calculate After Internal Standard FID Quantity FidQtyAfterIS = FidQty – (FidQty * (InternalStandardArea / ParameterInternalStandardArea – 1)) 3) Third we calculate [TotalPeak%] and FidQtyAfterISPer [TotalPeak%] = SUM of molecule [Peak%] in that peak FidQtyAfterISPer = FidQtyAfterIS * ([TotalPeak%] […]

Read More