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?