Use boolean checkbox to filter aggregate

I am trying to add one filter to an Aggregate, what I need to do is when the checkbox is selected I want to remove the products without description, from the aggregate( a list of products)

Bassically, I'm trying to add this filter to the aggregate but it's not working. Hasdescription is the variable attached to the checkbox, if it's selected I want to remove the products without description.


SyntaxEditor Code Snippet

If(HasDescription=True,Product.Description<>"",
   Product.Description<>"" or Product.Description="" )

Hi leo,

I think you can use filter

HasDescription = False or Product.Description <> ""

Dorine Boudry wrote:

Hi leo,

I think you can use filter

HasDescription = False or Product.Description <> ""

I'm afraid not because I have a condition, which is when I select the checkbox, I remove the products without description, only when is selected, otherwise I must show everything


Hi Leo,

Dorine has the answer: either HasDescription is False, which means everything goes, or, if HasDescription is True, Product.Description must be filled.

Note that

Product.Description<>"" or Product.Description=""

always resolves to True (it's either empty or not, there's no third possible state). I'm not entirely sure why your Filter didn't work, did you check the Executed SQL?