How to do percent with a field text

[#1]

Hello every body!

I need to do a percent in a field text but i could not

I have a situation below:

Project Situation

Test - Progress

Test1 - within

Test2 - Late

Test3 - Late

So i want in my graphic show Situation Late with 50%

I puted

Count ([DISTINCT Projeto])/ Count (TOTAL [DISTINCT Projeto])

but is not correct.

Can you help me?

Regards,

Ricardo

[#2]

Hi,

i think you've written brackets in wrong place. Try to write like this:

count

Milda

(distinct Projeto) / count (total distinct Projeto)

[#3]

Again:

count (distinct Projeto) / count (total distinct Projeto)

[#4]

((Count ([DISTINCT Projeto])/ Count (TOTAL [DISTINCT Projeto]) ) * 100 ) & ' %'

[#5]

i used this example bellow and is ok

count (distinct Projeto) / count (total distinct Projeto)

thank you for help

Best Regards,

[msteedle]

It's also missing any logic to count only "Late" projects in the numerator.

[#7]

of course Michael

Thank you.