Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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") ]
Hi
Try
1- Above(Sum(MP1),0,4)/Above(Sum(WOL),0,4)
Regards
You can also look into this
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) ) ) )