Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
can you tell me how to achieve the below requirement.
Avail Fields: Month, Sales.
Required Output: AvgSales
example--
for jan it showing jan sales
fer feb it showing jan+feb average sale
for mar it showing jan+feb+mar average sale
for Apr it showing feb+mar+Apr average sale
please help me on that.
Thanks
Perhaps try this also, still ordering by date.
=RangeAvg(Above(Sum(Sales),0,3))
Hi, you can use the following expression:
=RangeAvg(Above(Avg(Sales),0,3))
Hope this helps,
BR,
Vu Nguyen
not working
It has to be ordered by month.
Perhaps try this also, still ordering by date.
=RangeAvg(Above(Sum(Sales),0,3))