12 Replies Latest reply: Mar 25, 2017 1:12 AM by Ahmad Abdolkhalegh RSS

    Set analysis

    Ahmad Abdolkhalegh

      Hi all

       

      i have a table as follow, it has so many rows but here i bring 3 rows as example:

       

      BranchChannelInvoice No.Invoice DateInvoice Due DateAccounts Receivable

      A

      Retail101/01/201760 days after invoice date10
      AHospital201/01/201790 days after invoice date30
      AReferral301/01/2017120 days after invoice date50

       

      i want to create a measure or expression for overdue.

       

      our company has a rule for what to be called overdue as follow:

       

      if channel is Retail and it has passed more than 30 days from Invoice due date it would be overdue

      if channel is Referral and it has passed more than 120 days from Invoice date it would be overdue

      if channel is Hospital and it has passed more than 150 days from Invoice date it would be overdue


      Now i want to have an expression for overdue, which if i choose retail it shows me just retail overdue.

      if i use set analysis and filter channel, it always shows me all overdue for all channel

      am i suppose to use set analysis,How?

       

       

      thanks in advance