Define a Total Item on Parent based on Children's Type
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.
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.