Filtering on Boolean Values

Dwayne Cooper shared this question 3 months ago
Answered

Hi,


I want to filter a report on a boolean value but have the choice of true, false, or both. I have a column in a sales table that is called "primary admission" and a sale either includes "primary admission" or not. I'm doing summary numbers and I want the user to be able to choose to have "primary admission", "not primary admission", or both. What's the best way to do this?


Thanks,

Comments (3)

photo
1

Hi Dwayne,


It seems that the best way to do this will be to create a view level calculated field that converts this boolean to a string so that you can use an "IN LIST" filter type.


Does this sound like it will work in this case?


Regards,

Nathan

photo
1

Hi,

I tried Nathan's patch for a similar problem and it worked for me.

Thank you!

Lorenza

photo
1

Hi Lorenza,

Glad to hear it!

Dwayne,

I am going to close this case for now, but let me know if you have any questions or problems.

Regards,

Nathan