Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
alt(column(1)/column(2) ,0)
HTH
Sushil
Could you upload sample qvw?
Hi,
Attach some sample file, it helps to give solution quickly.
Regards,
Jagan.
Subbu,
Like this????
Thanks,
AS
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
Hi Subbu,
see the attached file .
hope this would be help you.