7 Replies Latest reply on Aug 26, 2016 1:48 AM by lei.chen.0

    Calculaltion Field going wrong

    Sandeep Kotha

      Hi All,

       

      I have two numeric fields and a date field.

       

      1.) Field 1

      2.) Field 2

      3.) Date

       

      I have used below code to create a new calculation field based on the latest date as shown below:

       

      if [Date]= {FIXED : MAX([Date])} then

      SUM([Field 1])/(AVG([Field 2]))

      END

       

      But it is throwing the below error:

      "Cannot mix aggregate and non aggregate comparisons or results in 'if' expressions"

       

      Is there any way to get the value of that division based on the latest date?

      Could someone help me on this?

       

      Thank you.

       

      Best Wishes,

      Sandeep