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

[deepakqlikview_123]

can u plz share sample data

[arasantorule]

Hi,

I believe the attached image is a table chart.

However you are expecting the highlighted result in the text box (Single Value).

Please can you verify if you are missing any more condition in set analysis.

Thanks.

[#4]

Hi

Yes that's correct .

I am not missing any conditions here.

Thanks

[#5]

Sample data attached, thanks.

[MindaugasBacius]

Try changing this:

[#7]

Hi Mindaugas Bacius

I need this results in a text box not a table chart

thanks

[#8]

Hi

Yes that's correct .

I am not missing any conditions here.

Thanks

[arasantorule]

Can you share the qvw if possible?

Are you calculating the value only when Score >=95.

Are you expecting the result in text-box for Department = {'Contracts', 'Spending','Agri'} and where Score >=95.

Thanks.

[#10]

That's correct