2 Replies Latest reply on Mar 30, 2012 4:38 PM by JamesMcPherson_1

# How To Calculate For A Result Based Off Two Other Field Criteria.

### Title

How To Calculate For A Result Based Off Two Other Field Criteria.

### Post

I am trying to have a Field Result to occur based on the criteria from two other fields.  I keep getting too few parameters.

What I am trying to do example:

Mail Swap 30=

If(Status = "Mail Swap") and If(GetAsNumber(Modified Date) ≤ Get(CurrentDate) + 30); "30"; "No"

• ###### 1. Re: How To Calculate For A Result Based Off Two Other Field Criteria.

You might want to look up if and case functions in FileMaker help.

If(Status = "Mail Swap" and Modified Date ≤ ( Get(CurrentDate) + 30 ) ) ; 30; "No" )

I'm assuming that Modified Date is a field of type date.

• ###### 2. Re: How To Calculate For A Result Based Off Two Other Field Criteria.

Thanks PMJ it got me where I wanted to be.  I thought I tried your formula but guess I was missing it.  You did end up with an extra ) between the 30's but I solved it.

Thanks again.