6 Replies Latest reply: Mar 12, 2018 4:10 AM by Manish Kachhia

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

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

My QVW

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

What exactly you want to do here?

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

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>

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

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 !!!

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

Hi Manish

Sorry for the wrong posting.

Paul Yeo

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

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 !!!