Cumulative Calculation for Rotation Days

[vikas_nandanwar]

Hi,

I have following Data set -

Month	Inv	Sales	Cum Inv	Month No	Avg Inv (=[Cum Inv]/[Month No])	YTD Sales	Rotation Days
Jan	100	30	100	1	100	30	100
Feb	120	25	220	2	110	55	120
Mar	100	35	320	3	107	90	107
Apr	110	40	430	4	108	130	99
May	150	50	580	5	116	180	97
Jun	155	55	735	6	123	235	94
Jul	160	40	895	7	128	275	98
Aug	170	60	1065	8	133	335	95
Sep	170	65	1235	9	137	400	93
Oct	160	55	1395	10	140	455	92
Nov	155	50	1550	11	141	505	92
Dec	150	60	1700	12	142	565	90

My Calculation for Rotation Days is  -

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

How to write expression for that?

Thanks,

Vikas

[uacg0009]

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]

Sorry for the error the formula should be

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

[sunny_talwar]

May be this

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

[sunny_talwar]

Check the attached