2 Replies Latest reply: Jul 25, 2013 3:30 AM by Kaushik Solanki RSS

    "contain" in expression

      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))