Selection on Set Analysis Values

[shumailh]

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"?

[shumailh]

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...

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