1 Reply Latest reply on Jan 17, 2014 10:53 AM by Tracy Rodgers

    Adding to calculated fields that are computed by a field

    Kat von

      i am trying to add two calculated fields that are computed by a field in a table

      IF FIRST()=0

      THEN

      WINDOW_SUM(IIF(SUM(IIF((Location=1 and [TimeStamp]<[Param_Date]),1,0))>0 AND

      SUM(IIF((D=104),1,0))>0,1,0),0,IIF(FIRST()==0,LAST(),0))

      END

       

       

      I seem to be getting empty calculations or it just recognizing one of the calculations. Here is what my calculation looks like

       

      Capture.PNG.png