Stock turnover ratio ?

[#1]

Stock Turnover Ratio

Sum(Stock Value)/((Previous 3 Months Sales *3)/9)

How to convert this into qlikview formula ?

[sushil353]

Hi,

Using rangesum u can solve ur expression like:

Sum(Stock Value)/((sum( aggr( rangesum( above( sum(Stock Value),0,3) ),Month))*3)/9)

HTH

Sushil