=num(Sum({$< Month_n ={"1"}>} sales/1000)/Rate) How to convert to SET expression

[paulyeo11]

Hi All

I have this expression work fine :-

=num(Sum({$< Month_n  ={"1"}>} sales/1000)/Rate)

Can some SET expert here help me convert to using SET expression. So that i dont need to use the additional field on Month_n

Remark :- Below expression is YTD work fine :-

=num(SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales/1000))

Paul

[paulyeo11]

My QVW

[MK_QSL]

What exactly you want to do here?

[paulyeo11]

I want to learn how to use SET expression , so that I don’t have to create month_n field. As in some of the input field like sales target , it does not have month_n field , so I can only use SET expression , as I aware SET expression don’t need month_n

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[MK_QSL]

To be honest.. I haven't understood yet.

Also, you wrote

I have try your recomeended expression , but it display null.

I don't know, what I have recommended !!!

[paulyeo11]

Hi Manish

Sorry for the wrong posting.

Paul Yeo

[MK_QSL]

I can still try to help you.. Let me know exactly what you want?

Looks like, you are posting more than one post at a time and mixing your replies !!!