AnsweredAssumed Answered

Troubleshooting formula evaluation in Conditional Formatting

Question asked by JohnNiebler on Oct 25, 2016
Latest reply on Oct 25, 2016 by user19752

Hello all,

 

I'm trying to apply some Conditional Formatting to some fields.  The formula involves trimming the FieldName, converting the result to a number, and comparing with another field.

 

I could put the formula here, but then I'm asking questions every time I try something.  What I'd really like to know is how to test formulas like this and have FMP show me the results.  Is there a Monitor section or another place I can run this formula and assign variables I can output to the screen somehow?  How does one troubleshoot these things?

 

Thanks,

-John

Outcomes