Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field called month and i need to avg the last two months data and the last two months data and next month data and so on how can i do this
You could try something like:
=rangeavg (above(Sum(x),0,1))
hi,
but i am not getting the exact answer
PFA
Small correction:
=rangeavg (above( Sum(MARC_FinMonth),0,2))
there is no difference between both the statements, the data for both the statements are same
there is any error in the above expression that calculates the sum of monthend inventories
PFA. Isn't this what you want?
hi that works well but i have a another question to u
question is that i have three fields LABST, UMLME, 3pl stock i need the monthend closing stock for this fileds and i have a condition for 3pl stock i.e
RecieveDate <= MonthEnd & GRDate = “ ” or > MonthEnd