Skip to Content
Former Member
Jan 15, 2006 at 07:12 AM

totals in the calculations


Hi! Experts:

I have a situation here.

I have 2 chars Country and Region.

Region will have some costs associated with them

These costs should roll up to become country cost.

I have to be able to do the following

1> I have to display the country cost on the country line

2> I have to be able to use the individual region cost in my calculations.

I have tried the following

For example

For US country

I have East and North region and they have 1000 and 2000 cost

Country Region regioncost countrycost

USA nothing nothing 3000

nothing East 1000 nothing

nothing North 2000 nothing

Here countrycost is a calculated key figure which adds regioncost of east and north regions.

Also the regioncost and contrycost are used in the calculations of some other columns

Is this possible?

Please help me here.