Expression - condition

[#1]

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 ?

Thank you in advance.

Duski

[alexandros17]

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)

[#3]

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.

Than you in advance.

Duski

[avinashelite]

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]

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.

[#6]

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.

Thank you in advance.

Duski

[maxgro]

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)

)

[avinashelite]

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 

[#9]

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

Duski

[alexandros17]

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