3 Replies Latest reply: Mar 13, 2015 7:33 AM by Onno van Knotsenburg RSS

    Expression in set analysis

      Hi guys,

       

      Have you ever used an expression as a "field" to be calculated from a set analysis? It would be like this:

       

      =(Avg({$<PeriodField   = {'$(=$(v_Param))'}, FieldA = {'A'}>} (Floor(MonthEnd(MakeDate(Year, Month)))-[DateFieldB])/(36525/100)))

       

      Is there anything I would need to be careful with when using this kind of expressions?

       

      Thanks for your help

       

      Sergio