Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to get sum(sales) date wise means accumulation of dates using as of table concept.
Any idea how to do that?
May be this?
Rangesum(Below(Aggr(Sum(sales),DateField),0),Above(sales,1,Rowno()))
Or
Aggr(Rangesum(Below(Sum(sales),0),Above(sales,1,1000)), DateField)
Hi
I need the mtd calculation in my as of table script and i need to implement MTD for my date collumn. So it should show the accumulated sum of sales from start date of month to that specific date.
So please give me a script that will calculate roolling period of date.
So please give me a script that will calculate roolling period of date.
You want to do this in Script?