Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think the sample data provided is not in full.
Thanks.
Can you share the sample data with all fields used in the expression
Thanks.
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 ?