Jul 10, 2007 at 07:10 AM
# Using result of a formula/summary field in another

Post Author: Computerra

CA Forum: Formula

I need to create a report like this:

H0 | H1 | H2 | H3 | Total--

n11 | n12 | n13 | n14 | <formula:n11

sum1|sum2|sum3|sum4|<formula:sum of this formula col>

%1 | %2 | %3 | %4 |

Here, %1-4 is the percentage obtained by dividing the sum1-4 by the value of <formula:sum of this col>My problem is that i cannot get the value of <formula:sum of this col> to divide sum1-4 with (Because it has no column name).How do I achieve this? any help is appreciated.thanks.