calculating percentages based on checkboxes
I am looking for a way to calculate a percentage based on a checkbox and if a value exists for a specific field. So basically: If(([Checkbox]=true) & [Field 1B]=" ", [Field 1A]/[Field 1B], ([Chec...
Forum Discussion
What is the field type for Field 1B?
- Numeric. I also tried Nz, no luck.
- The <> 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.
- I double checked, all Field #A or B are numeric lookup fields. Thanks for your help!
- Sorry 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.
