Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to get the sales of previous month, and the formula gives me the month of last year (november 2019), and what I want is the previous month of actual year (january 2020).
Formula : count({$<Month={"$(=max(Month)-1)"}, PDV_ModelName={'Available on EXIT'},PDV_Boolean={1},StoreDisabled={0}>} ProductId&StoreId)
It dosent' works, but I did find a solution.
count({<VisitDate={">=$(=MonthStart(Max(VisitDate),-1)) <=$(=MonthEnd(Max(VisitDate),-1))"},
PDV_ModelName={'Available on EXIT'},PDV_Boolean={1},StoreDisabled={0}, Month=>} ProductId&StoreId)
Try this,
count({$<Month={"$(=max({<Year = {"$(=Max(Year))"}>}Month)-1)"}, PDV_ModelName={'Available on EXIT'},PDV_Boolean={1},StoreDisabled={0}>} ProductId&StoreId)
It dosent' works, but I did find a solution.
count({<VisitDate={">=$(=MonthStart(Max(VisitDate),-1)) <=$(=MonthEnd(Max(VisitDate),-1))"},
PDV_ModelName={'Available on EXIT'},PDV_Boolean={1},StoreDisabled={0}, Month=>} ProductId&StoreId)