AnsweredAssumed Answered

Define a Total Item on Parent based on Children's Type

Question asked by LeoCA on Mar 18, 2009
Latest reply on Mar 19, 2009 by Orlando

Title

Define a Total Item on Parent based on Children's Type

Post

We need help on creating items on parent (Budget) based on children's (Funds) record type.

 

Funds have two columns fund_type and amount (in addition to referential keys). The values for fund_type are:

    IF - Initial_Funding

    AF - Additional Funding

    ...

 

There are several records for each fund_type.

 

We want to define Total_Initial_Funding, Total_Additional Funding,... on Budget.

 

We tried

 Total_Initial_Funding=Sum (If (Funds::Fund_Type="Initial_Funding";Funds::Amount ;0) )

It sums up all amounts in the Funds not just for "Initial_Funding".

 

Any idea how we can accomplish this.  Thanks.

 

LeoCA

 

Outcomes