explination?

[#1]

sum({$<PRODUCT ={$(=concat(‘”‘ & Product_ref & ‘”‘, ‘,’))}>} SALES) 

here i have product  and  product_ref  separate fields

product belonges to t1 table and    product_ref  belonges to  table t2.

to make relationship  between tl and t2 they have been used concat function   thats ok fine    but here

=concat(‘”‘ & Product_ref & ‘”‘, ‘,’))          what is use of this symbols '"' &product_ref &'"',','     pls give me explination about this

if i am selecting one product then next how it works?

[ashfaq_haseeb · Accepted solution]

Hi,

Replace your expression with below

=sum({$<PRODUCT ={$(=concat(chr(39)&Product_ref&chr(39),','))}>} SALES)  

It will let you select multiple entries/selections too.

Regards

ASHFAQ