Right...
Basically I have a table called FALL_IN
FAL_REVERSION_ID within this table is the field that links it to other tables.
within this table are 5 fields:
FAL_ID
FAL_REVERSION_ID
FAL_PROCESS_ID
FAL_PROCESS_DATE
FAL_PROCESS_DETAIL
The first function needs to:
Look for the field FAL_PROCESS_ID in the FALL_IN table, then match the value in the FALL_PROCESS_ID field to "noticeVacationSent" then when it matches that, return the value in the FAL_PROCESS_DATE. if however there is no date matched with this "noticevacationsent" field then to just return a 0 in its place.
The second one I have is:
I have two tables:
INVESTOR_INTEREST
PROP_COSTS
I need a formula that will sum all the PCT_INVOICE_AMOUNT fields within the PROP_COSTS table with the single value in in the INT_INVESTMENT_AMOUNT field in the INVESTOR_INTEREST table.
The problem I have is that the PCT_INVOICE_AMOUNT field contains more than one value per each case its linked to, I just want to sum these values to return one value, and not a list of the values.