I have a column that contains all sorts of integers. I have a parameter which allows the user to choose one of the three filter options: 'pos', 'neg', or 'all'
I then wrote formula that will display only the rows that match the filter like
if ({?myfilter} = 'pos') then
{number} >= 0
else if ({?myfilter} = 'neg') then
{number} < 0
This works, so then I went to do my last filter option, but wasn't sure how to do it. I then found that this works
else
{number} = {number}
Which I don't really like because of how it looks.
Are there other ways to do it?
IP Logged
