1 Reply Latest reply: Nov 24, 2009 5:21 PM by Shumail Hussain RSS

    Selection on Set Analysis Values

    Shumail Hussain

      I want to see the trend on set analysis value but i couldn't figure out how to make selection on it. Below are the two expression on which i applied set analysis.

       


      1. Revolver = Count({$<AIF = {P} , TXN_MainType = {Interest} , LoadDay_Active = {$(#=ReportDay)}>} AIF)
      2. Transactor = Count({$<AIF = {P}, LoadDay_Active = {$(#=ReportDay)}>} (AIF)) - Count({$<AIF = {P}, TXN_MainType = {Interest}, LoadDay_Active = {$(#=ReportDay)}>} (AIF))


      Can we make selection on expression "2. Transactor"?

        • Selection on Set Analysis Values
          Shumail Hussain

          OR

          Can anyone help me to write the opposite of the below code

           

          <pre>
          1. Revolver = Count({$<AIF = {P} , TXN_MainType = {Interest} , LoadDay_Active = {$(#=ReportDay)}>} AIF)


          Total = Revolver (80) + Transactor (20)
          Total = 100 = 80:20

          I have two variables Revolver and Transactor as mention in the code. both of them are inversely proportional to each other.

          I got the correct value for revolver but i couldn't get the inverse of it for transactor. I tried below code but it's not working.


          2. Transactor= Count({$<AIF = {P} , ~TXN_MainType = {Interest} , LoadDay_Active = {$(#=ReportDay)}>} AIF)



          Below is the code which works for Transactor but i cant make selection on it... Tongue Tied


          2. Transactor = Count({$<AIF = {P}, LoadDay_Active = {$(#=ReportDay)}>} (AIF)) - Count({$<AIF = {P}, TXN_MainType = {Interest}, LoadDay_Active = {$(#=ReportDay)}>} (AIF))


          Can anyone help me on this