RE:Ratio

[Chanty4u]

Hi all,

I need to calucalte the raio between

Frmulae: Onsite Hours/Offshore Hours

Dim:Period

sample data lik dis

year	period	on_0ff_flag	total_hrs	total_amt
2011	Per10	Onsite	152	456
2011	Per10	Onsite	152	456
2011	Per10	Onsite	72	216
2011	Per10	Offshore	152	304
2011	Per10	Offshore	152	304
2011	Per10	Offshore	8	16
2011	Per10	Offshore	142	284

how can i achve dis?

thanks

Suresh

[Anonymous]

this as well:

=num(Sum({<onsite_offshore_flag = {'Onsite'}>} total_hrs)/Sum({<onsite_offshore_flag = {'Offshore'}>} total_hrs)*100,'0')&'%'