3 Replies Latest reply on Sep 19, 2013 7:18 PM by alan foo

    Unaggregate calculation fileds with Max() date

    alan foo

      Hi,

      I am trying to create an unaggregated calculated field which I will call "Latest Count" that i am planning to use the following formula

       

      if ([posting date] = MAX([posting date]))

      then

      [id]

      end

       

      Where later i will do a COUNTD on the calculation. basically this would give me a count of the number of id's that is on the Max(posting date)

       

      Problem is that Max() would make the calculation into an aggregate. And this in turn will lead me to the "cannot compare aggregate with unaggregate" error

      Is there any other way i can get the Max(posting date) as a string ?

       

      Regards