Expression Issue

[#1]

Hi All,

Can you please help me with this question?

let me describe my issue

i have one small table which consists of EmpName,TrainingHours,MinimumHours

i want to create expression for this:i want to calculate only no of employees who have more traininghours when compared respective Minimumhours

I tried to use the expression in Text Objects

Thanks

Suresh

[rwunderlich · Accepted solution]

If the hours are already summarized by EmpName, you should be able to use:

=count(if(TrainingHours > MinimumHours,1))

If the hours are not summed, use an aggr like this:

=count(if(aggr(sum(TrainingHours) > sum(MinimumHours),EmpName),1))

-Rob

[#3]

My Data looks Like this

EmpName    TrainingHours   MinimumHours

E001            2                          3

E002           2                           3

E003           6                           3

E004           7                          3

[#4]

Hi Rob,

Thank you so much!

Expression works for me

Suresh