I'm testing our Zoho Reports and have a question.. I'm looking to calculate ratios using fields from related tables. I have three tables as follows:

Table A: Clients

Table B: Annual financial data for each client, joined to Table A by a client ID, for a series of years.

Table C: Additional annual financial data for each client, joined to Table by a client ID, for a series of years.

I want to use the data in Table B and C to calculate specific ratios for each client in Table A for each year. For example, for Client 1 I want to divide Table B.Field 1 by Table C.Field 2, for 2016 and for 2015.

I can't seem to figure out how to do that. I see I can create custom formula fields in a specific table, but I can't see how to get data in from a related table. In a query table only aggregate formulas are available.

How do I approach this calculation challenge.  

Any advice is appreciated.