"contain" in expression

[#1]

Hi,

i solve this problem yesterday, but with no result

I have a formula, where the first part defines the last one week of period for statistic, then some conditions and the last one is my request - possibility of limit concreete places of sale.

Please send me an advice where i should pleace a limited conditon for this "containing" expression.Thx a lot. Jaromir

sum({<Year={$(=max(Year))},Week={"$(=max({<Year={$(=max(Year))}>}Week))"},Buyer={'Man'},ItemSuplierCountry={'China'},Centre={'Prag,Viena,Boston'}>}(NAKPRO.qty)) 

[tresesco · Accepted solution]

try writing :

Centre={'Prag,Viena,Boston'} - wrong

as

Centre={'Prag','Viena','Boston'} - should be like

[kaushiknsolanki]

Hi,

     Try this.

     sum({<Year={$(=max(Year))},Week={"$(=max({<Year={$(=max(Year))}>}Week))"},Buyer={'Man'},ItemSuplierCountry={'China'},Centre={"Prag","Viena,Boston"}>}(NAKPRO.qty))

Regards,

Kaushik Solanki