REPORT %

[Guest]

How do i display % in my report below :

Branch Vol %
A 10
B 30
C 60
---
100

I expect result for A-10% , B-30% & C-60%

Thanks

 

[Guest]

Hi zyus,

How about "(Vol/Total)*100" to get the percentage, then format as a
percentage if you want to see the percent sign beside each one.

Hope this helps.

Damian.

 

[Guest]

Cannot be done....error "total"

Hi zyus,

How about "(Vol/Total)*100" to get the percentage, then format as a
percentage if you want to see the percent sign beside each one.

Hope this helps.

Damian.

 

[David F Cox]

[Vol]*100/sum([vol]) ?

Hi zyus,

How about "(Vol/Total)*100" to get the percentage, then format as a
percentage if you want to see the percent sign beside each one.

Hope this helps.

Damian.

 

[Guest]

The field "Total" in my example was assuming that you had a field called
"total".

Try sum([Vol]) if you don't have the Total calculated somewhere...

Damian.