formula for calculating sell through

[Anonymous]

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

[devarasu07]

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