Skip to Content
0
Former Member
Mar 05, 2009 at 02:21 PM

Can anyone help with a formula for either of these?

20 Views

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.