Textbox Result Display

[#1]

Hi Guys,

I have a question on where im having difficulties to get,

I created a textbox based on attached, I need the answer marked in Red to be displayed in Text box instead the one marked in Green is appearing.

Formula:

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

Regards.

Thabiso

[Chanty4u]

try

=num(count({<Department ={"=Count(score)>=95"}>}Deprtment)/Count(Score)*100 * -1,'#.')

[#3]

Hi Chanty,

How will i add Department Name Collections?

Regards.

[#4]

Hi Chanty,

This is not correct please advise how will i add the department name?

Regards,

[sunny_talwar]

Why do you want to pick 96.90? What is the reason to pick that rather than any other number here? Can you elaborate here?