Neil Scrivener Posted November 29, 2019 Posted November 29, 2019 Hi Guys, Sorry, me again with another question. I want to have a calculation which produces the results of a test, in effect there are 4 tests being conducted at once, which would be as follows: Number > Limit + Test said "Go" = Correct Number > Limit + Test said "Don't Go" = Wrong Number < Limit + Test said "Go" = Wrong Number < Limit + Test said "Don't go" = Correct Not being very good at Filemaker, I don't know how to do this - so what would be the best way? I guess this is too detailed for an IF statement? Thanks! Neil
comment Posted November 29, 2019 Posted November 29, 2019 (edited) This is not a question about Filemaker, but about logic. You have two propositions that can be either true or false, and a result that can be also true ("Correct") or false ("Wrong"). A truth table is a convenient tool for solving such problem: in your example, it could look like this: Number < Limit Test = "Go" "Correct" True True False True False True False True True False False False Now you just need to lookup the logical operator that matches the results column, and write your formula as = If ( Number < Limit xor Test = "Go" ; "Correct" ; "Wrong" ) Note that Number < Limit and Number > Limit are not collectively exhaustive; you need to extend one of them to include the case of Number = Limit. -- BTW, it would be convenient to make both Test and the result of this calculation Boolean - i.e. a number that can be either 1 (True) or 0 (False). In such case, the formula would be simply = Number < Limit xor Test and you could format the field to display a true result as "Correct" and a false one as "Wrong". Edited November 30, 2019 by comment
Neil Scrivener Posted November 29, 2019 Author Posted November 29, 2019 Thank you, that seems to work. The only issue I am having, is that some of this forms a calculation. So, for example, I have -7 - -10 and it's giving me a positive number, and huge percentage increase! How do I fix this?
comment Posted November 29, 2019 Posted November 29, 2019 I am afraid I don't follow the plot. The only thing I can say is that -7 - - 10 is a positive number (+3). But I don't see what this has to do with your original question.
Recommended Posts
This topic is 2073 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now