Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Folks, I need the Help to calculate the Following:
The first thing I needed to calculate was:
Consumables from Max Month or selection / Sum (Equipments bought on last 3 months)
Having sep/14 as an example:
Consumables Sep / Equipments Sep, Aug, Jul
= Sum({$<DateId = {"$(vMaxData)"}>} Suprimentos) / Sum({$<DateId = {">=$(vDataDeslocada)"}>} Equipamentos)
So far, it was Ok.
Then we came to the point I really have a Doubt:
I need the average of this expression from the past 3 months
Like calculating the expression for September, August and July and have their average.
I tried something like this, but it doesn't work.
= RangeAvg(Above(Aggr((Sum({$<DateId = {"$(vMaxData)"}>} Suprimentos) / Sum({$<DateId = {">=$(vDataDeslocada)"}>} Equipamentos)), Data),0,3))
I'm Attaching the example so you can help me:
Hi Vinicius, check the attachment to see if that's what you are looking for.