11 Replies Latest reply: Jan 13, 2015 12:34 AM by Douglas Mandrake RSS

    Set Analysis with field comparison

      error loading image

      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)