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
can u plz share sample data
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.
Hi
Yes that's correct .
I am not missing any conditions here.
Thanks
Sample data attached, thanks.
Try changing this:
Hi
Yes that's correct .
I am not missing any conditions here.
Thanks
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.
That's correct