If I have a field that = ABOV and another field location site as a value list is for a specific school.
How can I get a result "1"in the 10% field
I think a few more sentences would really help to nail this one down.
(1st field Category) and (2nd field is location site) drop down Value list and the 3rd field is which need to +1
ABOV and School Site =1
If Field1 is "ABOV" and Field2 is "A Specific Location", then set Field3 to 1.
If Category is "ABOV" and Location is 1, then set a field called "10%" to 1
Is that what you want?
Still having problems with the calculation
Ok I'm trying to get field for Category which is ABOV and Location to go into a field call Location code =1
ABOV and High School =1
Having problems wrapping my head around this. Can you post a sample file?
Ok I have a list of Location in the values List: then I have Category field is ABOV I want the field that said
Category and High School is = 1 in the field call Location Code
This is all coming through as nonsense to me.
I suggest you start by providing a list of the fields. Next to each field name, provide examples of values that they might have.
Then explain, in plain English, what you want to happen. Try using a similar format I suggested:
If FieldName is "value" and FieldName is "value", then FieldName should be "value".
Retrieving data ...