11 Replies Latest reply: Oct 31, 2017 1:20 AM by Cameron Vine RSS

    Nested if statement and aggregation issue

    Cameron Vine

      Below formula will not make the date on Wed 11-Oct under Ontime a 0, is still comes up as a 1. It works fine for the next line Tue 10-Oct.

       

      sum(

        aggr

          (

          If(

          min(Minutes)<0,1,

          If

          ((sum(aggr(If(min(Minutes)<0,1),Category,Milestone,Date))=0

          AND max(Minutes)>0),1,0)

              ),

        Status,Category,Milestone,Date)

      )

       

      Capture.PNG