3 Replies Latest reply: Apr 3, 2013 11:02 AM by Richard Lowe RSS

    Set Analysis 1 Field = Another

      I am trying to convert a functioning If/Then to set analysis.   The problem is in trying to only use values in the sum where the dates are equal.  Any ideas? 

       

      This expression works perfectly:

      =sum(if(Received='1' and ReceivedDate = DailyRateDate and DailyRateType='Daily', Sales/DailyRate))

       

      This expression does not work:

      =sum({<Received={1}, ReceivedDate={"=ReceivedDate=DailyRateDate"},DailyRateType={Daily},>} Sales/DailyRate)

       

       

      Thanks very much,

      Richard

       

      UPDATE -------

      Maybe Sample Data below will help.  This is essentially what I need to do:

       

      SALESTABLE                                   RATETABLE

      Sales     Rate     ReceivedDate          Rate          RateDate     DailyRate

      10          1          3/1/2013                     1               3/1/2013       .5

      20          1          3/5/2013                     1               3/5/2013      .55

      20          2          3/1/2013                     2               3/1/2013       .6