Sum( {$<~Ingredient = {“*garlic*”}>} Sales )

[arethaking]

Hi Guys,

What is the meaning of this set expression?

Sum( {$<~Ingredient = {“*garlic*”}>} Sales )

Thanks in advance.

[migueldelval · Accepted solution]

Hi Aretha,

Sum Sales when your field ingredients contens garlic and other text.

Sum( {$<~Ingredient = {“*garlic*”}>} Sales )

Sum(Sales )---> Principal expression

{$<~Ingredient = {“*garlic*”}>}  ----> Set Analysis: Limit your principal expression with a condition

$ ----> All your filters affect your expression

"..." ---> Use to find somthing

*...* ---> It makes that find all words that contens garlic

Regards

Miguel del Valle

[arethaking]

What is "~" in the expression?

[Frank_Hartmann]

sum( {$<~Ingredient = {"*garlic*"}>} Sales )

returns the sales for current selection, but with a forced exclusion of all Ingredients containing the string 'garlic'

[#5]

hi arethaking‌

In this below expression you using ~ symbol before the field.

It will exclude the values which consists of garlic.

Sum( {$<~Ingredient = {“*garlic*”}>} Sales )

[Frank_Hartmann]

If you want to force exclusion of specific field values, you will need to use "~" in front of the field name

[amit_saini]

Hi,

Please see the attachment to understand Set Analysis expressions.

Thanks,
AS

[migueldelval]

Sorry Arteha,

I didn´t see this, it exclude the condition.

Finally:

Sum Sales when your field ingredients haven´t garlic in your field ingredients.

Try this document, it´s so useful.

Set Analysis: syntaxes, examples

Regards

Miguel del Valle