Set Analysis Using Result of a column

[alucard_ae86]

Hello Experts,

I am trying to create an expression with set analysis that uses result of another column and a variable.
So I have a column that has DD/MM (compareDate) and i would like to concatenate this with a variable equals to /YYYY (vYear) and use it in a Set Analysis Expression . I am using the following Coding but it does not seem to work

Sum({$<BWVORG={'000','001','004','005','006','010'},BWAPPLNM={'MM'},BWBREL={1},BUDAT={"<=$(=Ceil(Concat([compareDate]&vYear))) "}>}BWMNG_KAR)

Any Suggestion ? 

Thank you in advance

[tresesco]

To concatenate two strings you used '&'. I guess you don't need concat() which is an aggregation function. Also, I could not understand why you used ceil(). Try to share a sample app with an explanation of expected output.