Set Analasys not equal with varible

[Rothschild]

Hi,

I try to reach sum(qty) without selected customers.

First I put the selected customers in a varible:

v_cus=chr(39)&Concat(distinct name_customer,chr(39)&','&chr(39))&chr(39)/

Result: 'a','b','c'.

Then I tried to put the varible in not equal formula:

=sum({<name_customer=-{'$(=$(v_cus))'}>}qty)

It does not work.

Do you have an idea?

[Anil_Babu_Samineni]

This should work

Variable: LET v_cus = '=chr(39)&Concat(distinct name_customer,chr(39)&'',''&chr(39))';

Expression: =sum({<name_customer-={$(v_cus)}>} qty)

[Rothschild]

Thanks.

I create the var in the varible overview, Are there changes in syntax?

[Anil_Babu_Samineni]

Should work from varaible overview as well, Definition should be like below and then try?

=chr(39)&Concat(distinct name_customer,chr(39)&'',''&chr(39))

[Rothschild]

One chr(39) missed in the beginning. (a','b','c')

[Anil_Babu_Samineni]

I would rather do simply like this : =Concat(distinct Chr(39) & name_customer & chr(39), ',')

[Rothschild]

Again, one chr(39) is missing.

[Anil_Babu_Samineni]

This should work until unless you are doing some wrong? Can you simply try in Text box and share the screenshot?

[Rothschild]

Maybe does anyone  have a solution??

[Anil_Babu_Samineni]

Will you be able to share sample application to demonstrate the same?