# Is there a calculation that says "If any field equals..."

## Recommended Posts

Is there a way to have a calculation that says:

If any field on this table has the value "True", then "Warning On" and if not, then "Warning Off" ?

Thanks for the help...

##### Share on other sites

You are a little vague with the details. So I'll just say, Yes?

##### Share on other sites

Table is a series of Yes or No questions, along with a field called Warning. the field, Warning, is a calculation, and I want it to calculate if any of the questions are answered "Yes". If they are all no, I'm fine, so the Warning field can be left blank, but if any of them are yes, either one or all, then I would like it to change the Warning field to read WARNING.

Hope this helps.

My issue is, I want to be able to add questions easily down the road, so I'd rather not have a calculation that is something like If Question 1 = Yes or Question 2 = Yes, etc. I can live with that, but I was wondering if there was a simple calculation that was something like If ( ANY FIELD = "Yes" ; "Warning" ; "" )

##### Share on other sites

I believe your questions - or rather answers - should be individual records in a related table (or at least individual repetitions of a repeating field). Then the current problem becomes trivial - and I would venture to predict, many other issues that you may not have encountered yet.

##### Share on other sites

There is probably a more elegant way to do this, but if I understand your problem, this would work.

question (text)

count_yes_c (summary) - count of yes_c

warning_c (calc) - Case(count_yes_c>0; "warning")

You could also have yes and no answers in separate fields to eliminate the yes_c step.

## 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.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

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

×

• ### Who Viewed the Topic

×
×
• Create New...