Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Suppose I have data from 2012 to July 2013, I would want an expression to calculate sales from inception that's the entire 2012 and 2013 up to June only.
Thanks
Hi
try like this
Sum({<Date={'>=$(=vStartDate)<=$(=vEndDate)'}>} Sales)
where vStartDate = Min(Date)
vEndDate = MonthEnd(AddMonths(Max(Date),-1))
Hi
try like this
Sum({<Date={'>=$(=vStartDate)<=$(=vEndDate)'}>} Sales)
where vStartDate = Min(Date)
vEndDate = MonthEnd(AddMonths(Max(Date),-1))