Announcements
cancel
Showing results for
Did you mean:
Not applicable

## Expression - condition

Hi, everybody,

I have an straight table with an expression:

count({\$<Kód={'M'},Druh={'VP'},Séria={'04. Nominácie_VÚ'}>}Projekt)

How is the correct syntax for setting condition for showing record only if expression value > 3 ?

Duski

1 Solution

Accepted Solutions
Partner - Champion III

In every expression you have to add the condition:

If(count({\$<Kód={'M'},Druh={'VP'},Séria={'04. Nominácie_VÚ'}>}Projekt)>3,

myexpression,

0)

48 Replies
Partner - Champion III

If(count({\$<Kód={'M'},Druh={'VP'},Séria={'04. Nominácie_VÚ'}>}Projekt)>3,

count({\$<Kód={'M'},Druh={'VP'},Séria={'04. Nominácie_VÚ'}>}Projekt)

,0)

Not applicable
Author

Thank you Alessandro,

but I think, my question was not clear for you.

My goal IS NOT TO SHOW ZERO, when the  result of the expression is < 3,

but my goal is TO HIDE THE RECORD, if the result of the expression < 3.

Duski

MVP

Hi Dusan,

We have option to suppress the 0 values that's why in the above expression he is setting to 0 so that it will meet your requirement of hiding the values

Anonymous
Not applicable
Author

Hi,

maybe you can use a calculated dimension:

if(

count({\$<Kód={'M'},Druh={'VP'},Séria={'04. Nominácie_VÚ'}>}Projekt) >3, YourDimension, null())

and set Supprese When Value is null.

Not applicable
Author

Thank you, Avinash,

now I understand - I need to put the formula above into the field definition, not into the condition definition.

But the solution doesn't work the way I need 😞 Maybe the problem is that there are many other columns in the table.

I need to show ONLY green records.

Duski

MVP

if you only have that expression

if (count({\$<Kód={'M'},Druh={'VP'},Séria={'04. Nominácie_VÚ'}>}Projekt) > 3,

count({\$<Kód={'M'},Druh={'VP'},Séria={'04. Nominácie_VÚ'}>}Projekt)

)

MVP

Hi Dusan,

What you mean by Green records here??

can you please elaborate your requirement and if possible post you app ? so that we can get the Exact requirement that you r looking for

Not applicable
Author

There are records 2,6,7,and 9 in the screenshot above marked green (entirely right, column name= Test).

Duski

Partner - Champion III

There is a condition: suppress 0 values, if this condition is set then the record disappear automatically (If this is your inly expression)

Hope it helps

Community Browser