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

[sunny_talwar]

Please check if this is what you want???

If yes then you need to change the total from expression total to sum of rows under the expressions tab of the chart properties

PFA the application also.

Best,

S

[wenkew186]

Thank you so much Sunindia,

it is work for this table. and I have a new requirement, I need add  2Column Expression to calculate Rate.

so I have try to change every total type for 'Rate' Column. but not any one to get right value.

you can click ">0<=26" button, the Rate will lose, it will happen when data has more than 2 rows.

please check the new sample.

[sunny_talwar]

When I click on '>0<=26', I see this:

This is not what you expect to see???

Best,

S

[wenkew186]

I set the Total type is Average for Rate. this is most close to result.

But the Total is the All column's average, is not really (Sales6/Sale5)*100%.

so it is not right.

like: (31/36)*100%  should be 86.11%  but not 87.31%

thanks,

Kevin.

[wenkew186]

it's the Rate column's average, not the (Sales5/Sale6)*100%. i have not find the right Total type for Rate.

[wenkew186]

if i set Expression Total for Rate.

then click on  '>0<=26' and '>26<=100' the Total was null, and click '>100' the Total is not right.

[wenkew186]

Hi Sunindia,

is any suggestion for this issue?

thanks,

Kevin.

[sunny_talwar]

Hey Kevin,

I did not get a chance to look at it. I promise, I will spend some time on looking at it today.

Best,

Sunny

[wenkew186]

Hi suninda,

it's Very grateful to you !!

thanks,

Kevin.