Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to show the number of units sold for last month using set analysis. My expression I have is below which I thought would work but doesn't.
Any help would be much appreciated.
sum({<UNIT.SOLD_MONTH = {"$(=month(addmonths(today),-1))"}>} UNIT.TOTALSOLD)
Thanks
Gareth
try like this...
Sum({<UNIT.SOLD_MONTH = {"$(=Date(AddMonths(Today(),-1),'MMM-YY'))"}>} UNIT.TOTALSOLD)
I think you are missing open and close parenthesis for Today() function. Try this:
Sum({<UNIT.SOLD_MONTH = {"$(=Month(AddMonths(Today(),-1)))"}>} UNIT.TOTALSOLD)
Well spotted Sunny T but it hasn't solved the problem unfortunately.
Thanks
There was also missing parenthesis at the end. Have you tried copy pasting the expression I have posted above?
Yes I've copied and pasted your expression it's still blank?
Can you share the values within UNIT.SOLD_MONTH
hi,
UNIT.SOLD_MONTH is Text or Number?
did you check it?
Hi,
Unit.Sold_Month is in the format MMM-YY
try like this...
Sum({<UNIT.SOLD_MONTH = {"$(=Date(AddMonths(Today(),-1),'MMM-YY'))"}>} UNIT.TOTALSOLD)
Hi
Try like this
Sum({<UNIT.SOLD_MONTH = {"$(=Date(AddMonths(Today(),-1),'MMM-YY'))"}>} UNIT.TOTALSOLD)