I'm trying to validate a Pressure_readings field based on a pressure_test picklist field value. I was able to save the formula without an error, but it doesn't work when I test it. Is there anything wrong with the formula, or is this type of validations not allowed in FSL flows?
I'm trying to do this in the same screen. I know we can do this with a decision element, but I'm trying to avoid that.
{!IF(
pressure_test= "yes",
AND(
NOT(ISNULL(Pressure_readings)),
Pressure_readings > 0,
FLOOR(Pressure_readings) = Pressure_readings
),
pressure_test= "No"
)}
Hello @Vinod Kumar the IF should be used this way :
IF ( condition, value if condition is true, value if condition is false )
In your case the condition is split on the test on pressure test equals to yes + the AND block after that does not contain the first test line. Besides, you should only indicate the value for your 2nd and 3rd attribute.
Eric