Hi,
I am trying to create a formula using two summarized fields that are calculated in Cross Tab Report. So for example I have two summarized fields x and y. X is the total project costs of all projects that the department funded, and y is the total amount of money that we contributed to all the projects that we funded. I want to create formula that calculates the ratio between x and y (i.e. x/y). Is it possible to place the formula right in the cross tab report. Please advise!
I am trying to create a formula using two summarized fields that are calculated in Cross Tab Report. So for example I have two summarized fields x and y. X is the total project costs of all projects that the department funded, and y is the total amount of money that we contributed to all the projects that we funded. I want to create formula that calculates the ratio between x and y (i.e. x/y). Is it possible to place the formula right in the cross tab report. Please advise!