SET expression How to add one more condition ?

[paulyeo11]

Hi All

Below expression working fine :-

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/1000)

I need to add one more condition to above expression , that is SOURCE = TDSS , So my expression as below :-

Sum({$<year = {$(=Max(year)-1)},SOURCE = {"TDSS"}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/1000)

But it display null. may i know where i go wrong ?

Paul

[kenphamvn · Accepted solution]

Hi

The expression is fine

Please check column name  SOURCE is correct? and  "TDSS" exist

you can test by using only new condition

Sum({$< SOURCE  ={"TDSS"}>} sales/1000)

Regards

An Pham

[paulyeo11]

Hi Pham

Your propose expression work fine , but when i add one more condition :-

Sum({$< SOURCE  ={"TDSS"}>,year  ={"2018"}>} sales/1000)

it does not work. Where i go wrong ?

Paul

[kenphamvn]

Hi

Try this

Sum({$< SOURCE  ={"TDSS"} ,year  ={"2018"}>} sales/1000)

Remove ">"

Sum({$< SOURCE  ={"TDSS"}>,year  ={"2018"}>} sales/1000)

Regards

An Pham

[paulyeo11]

hI pHAM

Thank you very much for your help.  Now work fine.

Paul