Total in Hierarchical report

[khshankar]

Using CR 10 & Oracle 10.

I created a Hierarchy report with two numeric columns. I want to sum both numeric column and show it as a third coulmn.

AA 10 20 sum(10 + 20)
BB 5 7 sum(5 + 7)
CC 2 10 sum(2 + 10)

I tried using running total & forumla, its not coming. Is there any way I can calculate the sum and show as third column.


Thanks.
Shankar

 

[Durango122]

hi
create a cross tab



Durango122
Remember to used all fingers when waving to policemen

 

[lbass]

You should explain whether you are showing us a sample of detail records with fields or formulas (and if formulas, what the contents are) or whether these are group summaries. Either way, you just need to create a formula that sums them:

//if fields:
{table.field1} + {table.field2}

//if formulas:
{@formula1} + {@formula2}

//if inserted summaries at a group level:
sum({table.field1},{table.groupfield}) + sum({table.field2},{table.groupfield})

//if inserted summaries at the report footer level:
sum({table.field1}) + sum({table.field2})

-LB