3 Replies Latest reply: Jul 19, 2012 2:25 PM by Benjamin Dykstra RSS

    Date Equal to Weekend Date in Set Analysis

      I need to include the condition POS date equal to Friday in the following expression:

       

      Avg(Aggr(Sum({$<CCYTD={1}>}OnHandDol),POSDate))

       

      I have tried to get this to work a number of different ways including:

      • using an if condition in the expression
      • using multiple different syntax forms of POSDate = Weekend(POSDate)
      • using an if condition before the expression

       

      each of these returns either the wrong value or nothing at all. Any idea of how to get this expression to work correctly? Any help would be greatly appreciated.

       

      Thanks,

       

      Ben D.