How to count where field values find in other field values?

[Anonymous]

Hi,

example:

count( {$<Products = {Handy, PC, Notebook}>} Products )

"Handy, PC, Notebook" are in the field "TopProducts". I want only count Products wich find in TopProducts. In the expression i must write each TopProduct. Is it possible only to write the fieldname TopProducts instead of each value from this field?

count( {$<Products = TopProducts>} Products )

But if no TopProducts value selected it doesn´t work.

How can i do it?

regards,

sam

[sunny_talwar · Accepted solution]

May be this:

Count({$<Products = p(TopProducts)>} Products )

[Anonymous]

Perfect, thanks!

[Anonymous]

How can i combine fields?

Count({$<Products = p(TopProducts)>} Products )

The field TopProducts are in a table where another field is like TopProductsLand. How can i combine this both fields in this expression. For example

Count({$<Products = p(TopProducts where TopProductsLand = "US")>} Products )

regards,

Sam

[sunny_talwar]

May be like this:

Count({$<Products = p({<TopProductsLand = {'US'}>}TopProducts)>} Products)