You didn't state the value of SystemPeriodTablulation::Service_Q1.
Sorry. That's a typo.
The condition is Self<SystemYTDTabulation::Service_Q1 - .1
Thanks for looking at it.
I performed test on my system and it worked correctlly. I setup two test field with your condition format. The number from your example tested false and the color didn't change and then change the number 6.5 which did test true and changed the color.
You could display a test field with each amount on the layout to besure the correct amount is being tested. If this is fine then
Maybe try deleting the field and recreate it.
There may be a typo somewhere in your conditoin so I would reverify that every is typed correctly.
Thanks for your help.
I've deleted and recreated the field without success. I'll try your suggestion about the test field.
I should have included a screen shot. The problem was that the offending condition was being evaluated as text; it had quotes around it. I deleted the quotes and it worked. I'll worry later about how the quotes got there. Thanks for your help.
You have 3 fields, not two:
The field name may be the same, but the the text to the left of :: is different in each case. This means you may have data from three different tables, 2 tables or just one data source table, but each are clearly different table occurrence names--indicating at least two are accessed via relationships. You'll need to double check your relationships and the data types of each Service_Q1 field.