Set Analysis 1 Field = Another

[#1]

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

[manideep78]

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

[#3]

Tried with similar expressions, it works fine for me.

Is it typo error, an extra comma symbol at the end of set modifier..

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

[#4]

The comma was a typo in the post.   I tried that one and it did not work for me.    Not sure what to try next.  i thought about using the working if/then in the script.  Maybe your script suggestion would work too, wil have to think about how to implement that one.