6 Replies Latest reply: Sep 28, 2016 1:05 PM by Sunny Talwar RSS

    If statement within set analysis

    Sean Villacorte

      Hi,

       

      I'm struggling to make my set analysis expression to work. I'm trying to get the total time where ordernumber is equals to the choosen ordernumber on my filter pane and requestdescription is not blank. Here's my code:

       

      sum ({1<[OrderNumber]=P({$<[OrderNumber]={"if(len(trim([RequestDescription]))>0,

      [OrderNumber])"}>}[OrderNumber])>}

      num#((Interval([StpDate]-[StrtDate], 'ss'))/60/60))

       

      Appreciate any inputs or suggestions... Thanks in advance. -sv