12 Replies Latest reply on Mar 13, 2018 10:27 AM by Jim Dehner

    Window sum field with Fixed : {}

    Tarek Elduzdar

      Hello,

       

      I have 2 fields where i calculated using window sum :   "[3M_OT])" and [3M_PERFORMANCE]

       

      I need to get the below formula to work in order to use this field to count the group for each category.

       

      I have the error in the screenshot.

       

       

      This is the formula :

       

      {FIXED [Supplier Id],[Airline Id],[Rated],[Repairs Spares],[Group],[Period Date]:

      IF [Parameter 1]="Current" AND

      SUM([3M_OT])/SUM([3M_PERFORMANCE])>=0.95 THEN "GREEN"

      ELSE "RED" END}

       

       

       

      Please let me know how can i get around this error.

       

       

      I am sorry but i really can't upload any worksheets. Would appreciate your help if possible, thanks.

       

       

       

       

      Regards,

      Tarek