Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
This should work
Variable: LET v_cus = '=chr(39)&Concat(distinct name_customer,chr(39)&'',''&chr(39))';
Expression: =sum({<name_customer-={$(v_cus)}>} qty)
Thanks.
I create the var in the varible overview, Are there changes in syntax?
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))
One chr(39) missed in the beginning. (a','b','c')
I would rather do simply like this : =Concat(distinct Chr(39) & name_customer & chr(39), ',')
Again, one chr(39) is missing.
This should work until unless you are doing some wrong? Can you simply try in Text box and share the screenshot?
Maybe does anyone have a solution??
Will you be able to share sample application to demonstrate the same?