Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to use a calculation in a chart with YearMonth as dimension and a datefield StockDate (YYYYMMDD). I trying to use following expression but it relly doesn't work.
count({<StockDate ={">=$(=Date(addmonths(monthend(Max(StockDate), -12), 'YYYYMMDD'))) <=$(=Date(addmonths(Max(StockDate), -1), 'YYYYMMDD'))"}, GroupID= {'North'} >} CustomerRoID)
Any one that have any suggestions?
Try to correct the brackets:
=count({<StockDate ={">=$(=Date(addmonths(monthend(Max(StockDate)), -12), 'YYYYMMDD'))) <=$(=Date(addmonths(Max(StockDate), -1), 'YYYYMMDD'))"}, GroupID= {'North'} >} CustomerRoID)
HI
Try like this
count({<StockDate ={">=$(=Date(monthend(addmonths(Max(StockDate), -12)), 'YYYYMMDD'))<=$(=Date(Monthstart(addmonths(Max(StockDate), -1)), 'YYYYMMDD'))"}, GroupID= {'North'} >} CustomerRoID)
Hope it helps