how to calculate percentage in repirt

abieyuwae

New member
Local time
Today, 13:07
Joined
Oct 20, 1999
Messages
6
I'm trying to calculate percentage in a report.
example:
total hrs: =sum([hrs])
percent: =[total hrs]/[grand total]

grand total:=([hrs])

my total hours is fine...but the percentage gives me a bunch of parameter values i never specified and it doesn't show the percentage, only the total hrs shows.
please could anybody help ...as any suggestion is welcome.
thank you.
 
Try this,

([total hr]*100)/[Grand hr]-100
 

Users who are viewing this thread

Back
Top Bottom