Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to convert Month_n to SET ?

Hi All

I have below expression from Table 2 which is using Month_n and need to select current month and year :-

money(

sum({$<Month_n={$(=max(Month_n)-0)}, month=, year=>} $(ColumnDim51)/$(Columndim89)/1000)

,$(vMoneyFormatK))

I like to change the above expression by using SET with don't need to select on current month and year. and it will return current month sales.

Paul

0 Replies