Forum Discussion
EvanMartinez
6 years agoQrew Elite
What is the field type for Field 1B?
- CourtneyRapp6 years agoQrew CadetNumeric. I also tried Nz, no luck.
- EvanMartinez6 years agoQrew EliteThe <> operation should work just fine with a Numeric type field I have a number of fields that use it in calculations in my live apps. If you are having an issue with that operator I would confirm the field types of the fields in use and make sure they are all Numeric or formula Numeric fields. If you are still having issues then I would suggest creating a case with the Care team so they can take a look at the formula inside of your application and see what might be causing you to get those error messages as it could be a type mismatch that is sometimes easier to identify from inside the application.
- CourtneyRapp6 years agoQrew CadetI double checked, all Field #A or B are numeric lookup fields. Thanks for your help!
- EvanMartinez6 years agoQrew EliteSorry I couldn't help more, a Care rep should be able to get in your application and pick apart what might be causing that error to flag when building that formula and help you get across the finish line. Thanks for your time today Courtney.