Calculating Percentages in Impromptu.

[Swathi37]

Hi,

I need to calculate percentages from two different list reports.
I use 2 tables
Customertable and customerlogintable.
Link is based on custID.
Listreport 1
COunt of Customers who are Externalcustomers
External
--------
250

Calculation: Count(CustID)
filter: ProdID='ABC'
Note: I use only Customertable.

Listreport2
Count of customers logged on during last week.
External
--------
200
Calculation: Count(CustID)
Filter: Accessdate between 2003-10-01 to 2003-10-07 and url=125 and ProdID='ABC'
Note: I use both Customertable and Customerlogintable.
Percentage required
External
--------
0.8 i,e 200/250
I am using a main report that has 2 prompts fromdate and todate. all other reports are subreports linked to the main report. Is it possible to link subreport to a subreport?

How do I calculate the percentage?

Please let me know and your help is greatly appreciated.

Thanks
Swathi.