% calculation in straight table

[#1]

I m using straight table to calculate the total tickets field and resolved ticket field

table ticket  resolved ticket

10                  5

12                 3   

11                 -
13                4

14                 -
  

the data displayed like this. to use the two fields to calculate the %. the % calculating I am using this condition like column(1)/column(2) but data not getting. because in resolved ticket field some data having '- ' like this. I m using suppress to null value but also not getting. how to calculate the %  anyone plz tell me .....urgent 

[sushil353]

Try this:

alt(column(1)/column(2) ,0)

HTH

Sushil

[senpradip007]

Could you upload sample qvw?

[jagan]

Hi,

Attach some sample file, it helps to give solution quickly.

Regards,

Jagan.

[amit_saini]

Subbu,

Like this????

Thanks,

AS

[#6]

in the above example I m using the your expression but total % sum getting 0.0%.

but I need the total( total tickets )/total(resolved tickets) =%of resolved tickets  means 12/60=% resolved tickets  plz tell me any expression urgent  

[Anonymous]

Hi Subbu,

see the attached file .

hope this would be help you.