Hello all,

I have a report with several groupings.  On the report footer and a grouping footer I am using the same formulas - sum(Total hours), sum(total direct hours) and percent (total direct hours/total hours).  Simple.

The total hours and total direct hours work as designed.  On the report footer they total everything from the report and on the group footer they total only those in that grouping.   However, the percent is using the total hours for the whole report no matter where it is?  So, on the report footer the percent is 74.43, which is correct, but it's the same for every total on the group footer also??

Can anyone shed some light on this?

Thanks!

Sorry, I forgot to mention that the direct hours is the sum of a formula field

if {prhpost.orglevel2}  in ["1", "2"]
 then {prhpost.quantity}
 else 0

My formula is sum({@Direct Hours})%sum({prhpost.quantity})

This is giving me an error:  'The field name is not known'

Group name is   "Group Footer #1: prhpost._orglevel1-A"

I have tried
sum({@Blind Hours},{Group Footer #1: prhpost._orglevel1-A:})%sum({prhpost.quantity})

sum({@Blind Hours},{prhpost._orglevel1-A})%sum({prhpost.quantity})

sum({@Blind Hours},{Group Footer #1})%sum({prhpost.quantity})

All of these give me the same error?