11 Replies Latest reply: Nov 22, 2011 8:38 AM by B Y RSS

    Expression SUM with concatenation

      hello,

       

      I have a problem with my expression.

      I try to do a sum, with a concatenation of 2 fields.

       

      [civile_Year/month] = 01.2011, 02.2011, 03.2011, 04.2011 ....

      [Num_month] = 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12

      [civile_year] = 2008, 2009, 2010, 2011

       

      I want to display the volume for the max date that the user have selected.

      for example : if he select [civile_year] = 2011 and [Num_month] from 01 to 10, I want to display the volume for [civile_Year/month] = 10.2011

       

      My expression :

       

       

       

      =sum( {<[civile_Year/month]= {$(=MaxString([Num_month]))&'.'&[civile_year]}>} Volume)

       

      I have try lots of synthaxe like :

      =sum( {<[civile_Year/month]= {(concat($(=maxstring([Num_month]))&$(=max([civile_year])),'.')}> } Volume)

       

      Someone can help me ?

      Thanks in advance.