Jump to content
Sign in to follow this  
JTSmith

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 this post


Link to post
Share on other sites

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

Share this post


Link to post
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 this post


Link to post
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 this post


Link to post
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)

answer (text) - on the layout, a yes-no radio button

yes_c (calc) - case(answer="yes", "mark")

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.

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.