3 Replies Latest reply on Oct 25, 2016 11:08 PM by user19752

    Troubleshooting formula evaluation in Conditional Formatting

    JohnNiebler

      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