Set Analysis with field comparison

[#1]

I want help with month comparison. I want help on a set analysis expression for selection such that when ReceiptMon is selected it would display records which salesmon is the same as ReceiptMon. I have tried this but no records .

For example if Jan is selected for ReceiptMon it should display records whose ReceiptMon is Jan and SalesMon is Jan.

Any help would be appreciated.

SUM({$<SalesMon = ReceiptMon>} ReceiptAmount)

[#2]

Hello Abraham,

my first idea wasn't so bad. And with it you pointed into the right direction. Look at your first post and try your expression with a good old if-statement:

sum(IF( ReceiptMon= SalesMon, ReceiptAmount, 0 ))

Hope this helps right now

RR

[themandrake]

hi Abraham,

this is an old question you have and i see that It has been unanswered since 2010. might be a closure to it if this works:

=sum( {$<SalesMon = {"=ReceiptMon"}>} ReceiptAmount)

best regards