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

    Window sum field with Fixed : {}

    Tarek Elduzdar



      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


      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.