DATA VALIDATION: Boolean Fields

I want "False" values in a Boolean field to be flagged.


I'm calculating the field value with this expression:
If(ROUNDED_PRICE=Math.Round(PRICELIST_VALUE,2), "TRUE", "FALSE")

It is calculating correctly.
I am trying to validate the field with these settings:


But the falses aren't turning pink.

NOTE:  Originally I was using Yes/No, but I switched everything to TRUE/FALSE to try to get it to work.
Kyle Souza
Data Wizard
P&P Oil & Gas Solutions

Best Answer

  • kylesouzakylesouza Posts: 129 ✭✭
    Accepted Answer
    Figured it out, i needed to change the Validate Expression to  PRICE_MATCHES_="TRUE"
    Kyle Souza
    Data Wizard
    P&P Oil & Gas Solutions
Sign In or Register to comment.