5 Replies Latest reply on Jul 16, 2018 4:02 AM by meenu choudhary

    Meaning of calculation field/symbol means

    Haan Haan

      May I know what does the calculation field below mean? There of the calculation fields are linked.

      1. Max Date

      { FIXED :MAX([Date])}

       

      2. Sales Cal

      IF [Date] = [Max Date] THEN

          [Sales]

      END

       

      3.

      SUM([Sales Cal])

      /

      SUM(IF [Date]<>[Max Date] THEN [Sales] END)

      -1

       

      Thanks