Last Month Units - Set Analysis

[Anonymous]

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

[sunny_talwar]

I think you are missing open and close parenthesis for Today() function. Try this:

Sum({<UNIT.SOLD_MONTH = {"$(=Month(AddMonths(Today(),-1)))"}>} UNIT.TOTALSOLD)

[Anonymous]

Well spotted Sunny T but it hasn't solved the problem unfortunately.

Thanks

[sunny_talwar]

There was also missing parenthesis at the end. Have you tried copy pasting the expression I have posted above?

[Anonymous]

Yes I've copied and pasted your expression it's still blank?

[sunny_talwar]

Can you share the values within UNIT.SOLD_MONTH

[sasikanth]

hi,

UNIT.SOLD_MONTH is Text or Number?

did you check it?

[Anonymous]

Hi,

Unit.Sold_Month is in the format MMM-YY

[PradeepReddy · Accepted solution]

try like this...

Sum({<UNIT.SOLD_MONTH = {"$(=Date(AddMonths(Today(),-1),'MMM-YY'))"}>} UNIT.TOTALSOLD)

[MayilVahanan]

Hi

Try like this

Sum({<UNIT.SOLD_MONTH = {"$(=Date(AddMonths(Today(),-1),'MMM-YY'))"}>} UNIT.TOTALSOLD)