nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Multiple number values in condition or variable.

alecsia

Good morning!
 
I need some help regarding multiple conditions in the Expression Builder.
 
I need PERSONAL_ID to be counted based on two conditions: row["C_CATEGORY_POSITION"] must be 1, and row["AGE"] must equal 59 and 60 simultaneously. 
 
For this purpose I write very simple expression in the Builder Expression of the Aggregation option:
<pre class="_prettyXprint">
if (row["C_CATEGORY_POSITION"] == 1 && row["AGE"] == 59){row["PERSONAL_ID"]}</pre>
This works perfectly when I equal row["AGE"] to only one number, but how can I insert two or more numbers? I even tried to declare a variable there, but I didnâ€™t get any resultsâ€¦
 
Also I tried to create a separate Variable in the Data Explorer, I created a Report Variable with Default Value. And again when I insert only one value it works perfectly.
 
How can I set many number values to a Variable or in condition?

Find more posts tagged with

Comments

pricher

Hi,
 
Try building your aggregation as follows:

alecsia

Thank you a lot, this works exactly as I wanted!!!