topic Re: hard calculation in range of weeks in App Development

hard calculation in range of weeks

Mon, 21 Aug 2017 08:18:55 GMT

Hi community,

I need a help on a calculation, and after many tries, I still can't find the solution of my problem, here is the situation:

My field is already created, it is called Week and contains as values : 2017W01, 2017W02 ..to.. 2017W28

what i want to do is :

Calculate, for each week 'x' in my field the following amount :

1 - [ (sum of the 'MP1' for the weeks : "x-4" to "x") / (sum of the 'WOL' for the weeks :"x-4" to "x") ]

kenphamvn — Mon, 21 Aug 2017 10:28:10 GMT

Try

1- Above(Sum(MP1),0,4)/Above(Sum(WOL),0,4)

Regards

sunny_talwar — Mon, 21 Aug 2017 11:24:19 GMT

You can also look into this

Mon, 21 Aug 2017 12:19:10 GMT

Thank you for your help,

I tried this expression and It worked very well :

1- ( ( RangeAvg( above( Sum([Nb MP 7 days] ),0,5 ) ) ) / (RangeAvg( above( Sum( [Nb WOL 7 days] ),0,5) ) ) )