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

# Selection on Set Analysis Values

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

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