Skip to Content
0
Former Member
Jul 10, 2007 at 07:10 AM

Using result of a formula/summary field in another

20 Views

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 n12n13 n14>n21 | n22 | n23 | n24 | <formula:n21n22 n23n24>n31 | n32 | n33 | n34 | <formula:n31 n32n33+n34>
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.