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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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