Text object result

[#1]

Hi guys

I have an issue where the results in my text box object is different comparing it to my table chart, please see attached image for more clarity(Formula below).

I am trying to display the score by department and i need the score in RED to appear in my text object, but instead the score in GREEN is appearing, is there something I'm missing??(Please have a look at the attached to see what I mean)

=Num(sum({< Department = {'Contracts', 'Spending','Agri'} >}Score >=95) / Count(Score)*100 * -1,'#.')

Kind regards,

Justin

[arasantorule]

I think the sample data provided is not in full.

Thanks.

[arasantorule]

Can you share the sample data with all fields used in the expression

Thanks.

[qliksus]

Looks like you are trying to create Average but as per the data and the calculation you posted

The value of sum({< Department = {'Contracts', 'Spending','Agri'} >}Score >=95)  =  196

The value of  Count(Score) = 17

The result is thus  = 11  but ur chart is showing 0.85

Can you post  a sample file to understand this better ?