jspartz
2007-01-09, 11:53 PM
Does anyone know a lot about these formulas. There's not much documentation on it. I have a few questions.
1. I see that under calculated value, you can pick other types other than number. But, how do I add text together. Say I have one field "Field1" with text "String1" and another field "Field2" with text "String2" and I want it to say "String1 String2", what's the formula? I've tried Field1 + Field2 and Field1 AND Field2, but they didn't work.
2. Can I combine number fields with text fields, like "200" and "NET" into one field?
3. Can I get a conditional statement that says take two fields and use the greater of the two?
1. I see that under calculated value, you can pick other types other than number. But, how do I add text together. Say I have one field "Field1" with text "String1" and another field "Field2" with text "String2" and I want it to say "String1 String2", what's the formula? I've tried Field1 + Field2 and Field1 AND Field2, but they didn't work.
2. Can I combine number fields with text fields, like "200" and "NET" into one field?
3. Can I get a conditional statement that says take two fields and use the greater of the two?