Calc Statement Maybe if statement

[agaperrk]

I have a field that is a calculation field, I have another field that is a check box.

In the calculation field the calculation will look at two other fields if they equal or better the amount that it needs then It returns a Text statement.

all I want the Check box to do is that if that box is checked the statement does not show.

Example

Case(total1 ≥ 3 and total2 ≥ 2 ;"Text")

This will work fine until I through in the additional check box and I cannot get the file to work.

Thanks in Advance.

[Fitch]

Are you saying that this doesn't work:

Case(total1 ≥ 3 and total2 ≥ 2 and checkbox = 1 ;"Text")

Is the checkbox a number? What value list did you use to format it? Is it a single checkbox or does the field hold multiple values?

[agaperrk]

The Check box will return a Yes

It is a single value. The Calculation works, but when I throw in the 3rd element with the additional field I cannot get the right value.

Edited May 16, 2008 by Guest

[mr_vodka]

Case(total1 ≥ 3 and total2 ≥ 2 and checkbox = "Yes" ;"Text")

[agaperrk]

Case(total1 ≥ 3 and total2 ≥ 2 and checkbox = "Yes" ;"Text")

I need the oppsite. The Statement need to be present if the total of 1 and 2 are True. The 3rd thing is I want the Check box to make the statement false.

I want the checkbox to bypass the calc and show a blank field.

So the calc will show the text if they are true and nothing if they are false. I want to be able to change the text to a blank field when I check the box.

[David Jondreau]

I need the oppsite. The Statement need to be present if the total of 1 and 2 are True. The 3rd thing is I want the Check box to make the statement false.

I want the checkbox to bypass the calc and show a blank field.

So the calc will show the text if they are true and nothing if they are false. I want to be able to change the text to a blank field when I check the box.

You've got three cases, Checkbox = Yes, fields meet criteria, and fields don't meet criteria (when checkbox is empty). What do you want to happen in the last case?

Case(

checkBox = "yes"; "";

total1 ≥ 3 and total2 ≥ 2 ;"Text";

:)

[comment]

How about:

Case ( total1 ≥ 3 and total2 ≥ 2 and checkbox ≠ "Yes" ; "Text" )

[David Jondreau]

Clearly I'm working on a sleep deficit today. I misread the question and thought there was a missing potential result.

I would write it (esp if the total fields were unstored):

Case(

checkBox = "yes"; "";

total1 < 3 or total2 < 2 ;"";

"Text")

[agaperrk]

Clearly I'm working on a sleep deficit today. I misread the question and thought there was a missing potential result.

I would write it (esp if the total fields were unstored):

Case(

checkBox = "yes"; "";

total1 < 3 or total2 < 2 ;"";

"Text")

I most likely explaining it wrong.

The Calculation will put the text in the box.

If a person has worked three class and given 2 talks then. He is "eligible" to teach a class.

This part of the calc works. Eligible is the Word the Text puts in the field.

I have a Check box that if it is checked it will override the calculation and leave the field blank.

The Word "Eligible" will not be put in the Field. Therefor allowing me to filter out someone I do not want to teach or he has taught that class before.

[David Jondreau]

I most likely explaining it wrong.

The Calculation will put the text in the box.

If a person has worked three class and given 2 talks then. He is "eligible" to teach a class.

This part of the calc works. Eligible is the Word the Text puts in the field.

I have a Check box that if it is checked it will override the calculation and leave the field blank.

The Word "Eligible" will not be put in the Field. Therefor allowing me to filter out someone I do not want to teach or he has taught that class before.

I think everyone that has responded to you has (eventually) understood your question. If you make the appropriate substitutions ( the name of the check boxed field for "checkBox", the word "Eligible" for "Text") you will get the behavior you're looking for.

Have you tried that? How is the result different than what you expected?

[agaperrk]

I think everyone that has responded to you has (eventually) understood your question. If you make the appropriate substitutions ( the name of the check boxed field for "checkBox", the word "Eligible" for "Text") you will get the behavior you're looking for.

Have you tried that? How is the result different than what you expected?

I inserted the calculation and the result is the Text remains in the box so it did not work.

[comment]

See if this helps:

Eligible.fp7.zip

[agaperrk]

See if this helps:

That Worked I had to change one of my fields to a number field.

Thank