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