I'll like to create a filter to capture between 2 ranges .. For Example - I want to capture between where fund ID is greater or equal to 30 but less or equal to 100. Fund ID >=30 and <=100. How do I write that as a custom filter
Will this be the right command:
If ([Fund ID] >= 30 and [Fund ID] <= 100 then 1 or else 0 end if
Solved! Go to Solution.
If you want you can put the expression directly into the filter tool to do it in one step. Otherwise you create the flag in a formula tool and probably need to do a filter after straight after.
You are right: [Fund ID] >= 30 and [Fund ID] <= 100
Will evaluate to True (and records come out the True anchor) for values between 30 and 100 inclusive.
I leverage using the formula instead of the filer..
If [FUND ID] >= 30 and [Fund ID] <= 100 then 1 or else 0 end if - Im using this one as a custom filter but its giving me an error with 'else"
Forgot to add the parenthesis -I think this is the right one -- running now
If ([FUND ID] >= 30 and [FUND ID] <= 100) then 1 or else 0 end if