Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have two columns purchase quantity and sales quantity
Purchase_quantity= total quantity/1 as Purchase quantity ( in load script)
sales quantity=total quantity/1 as sales quantity(in load script)
In chart expression
what will be the expression for calculating sell through if I have sales quantity and purchase quantity
Hi,
in General Sell Through % formula is like that,
=sum(SoldQty)/sum({<PO_Type={'NB'}>} OrderQty)
Note:
OrderQty from Purchase Order Fact Table.
SoldQty from Sales Fact Table
PO Type : NB which is initial order. based on your flag and requirement u can use it.
P.S; u check with your Business User for the Confirmation.
Thanks,
Deva