Jump to content
Sign in to follow this  
smith

two "ifs" in one calculation ?

Recommended Posts

New to FileMaker - trying to calculate fields based on two variables: for a school math assessment database I want to set some fields that will return certain numbers if two things happen - if the year is "xxxx" and if the grade level is "xxxx" then the certain fields will equal specific values. I started with a Case calculation for each of those certain fields, but then I realized that those results would only be good for one year. I didn't know how to make the results be possibly different in different years.

If the Benchmark Level is gr3, then Number Sense would be equal to 6, but how would I write it to be if the year is 2003-2004 and the Benchmark Level is gr3, then Number Sense would be equal to 6. If the year is 2004-2005 and the Benchmark Level is gr3, then Number Sense is equal to 7. Please help.

Forum Help.zip

Share this post


Link to post
Share on other sites

Assuming your "year" and "Benchmark Level" fields are both text, and that your data in those fields are 2003-2004, 2004-2005, gr3

Number Sense calculation would look like this.

Case(year = "2003-2004" and Benchmark Level = "gr3" , 6,

year="2004-2005" and Benchmark Level = "gr3", 7)

HTH

Lee

cool.gif

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.