topic Re: Cumulative Calculation for Rotation Days in QlikView

Cumulative Calculation for Rotation Days

vikas_nandanwar — Thu, 30 Nov 2017 10:22:03 GMT

Hi,

I have following Data set -

My Calculation for Rotation Days is -

(Month No * 30) / [(Avg Inv)/(YTD Sales)]

How to write expression for that?

Thanks,

Vikas

uacg0009 — Thu, 30 Nov 2017 10:41:42 GMT

Hi Vikas,

Sorry I didn't understand what you want to calculate, because according to what you said :

Rotation Days = (Month No * 30) / ([Avg Inv] / [YTD Sales])

Then for your first line data, the Rotation Days should be :

1 * 30 / (100 / 30) = 9

But your result is 100.

Why?

Thanks.

Aiolos Zhao

vikas_nandanwar — Thu, 30 Nov 2017 10:55:30 GMT

Sorry for the error the formula should be

Rotation Days = (Month No * 30) * ([Avg Inv] / [YTD Sales])

sunny_talwar — Thu, 30 Nov 2017 13:38:01 GMT

May be this

([Month No] * 30) * ((RangeSum(Above(Sum(Inv), 0, RowNo())) / [Month No])/RangeSum(Above(Sum(Sales), 0, RowNo())))

sunny_talwar — Thu, 30 Nov 2017 13:41:31 GMT

Check the attached