cancel
Showing results for 
Search instead for 
Did you mean: 

Validation

Highlighted
Image Sensor
IF(OR(@OPERATING_UNIT (1)@ ="A",@OPERATING_UNIT (1)@ ="X",@OPERATING_UNIT (1)@ ="R"),AND(NOT(ISBLANK(@OPERATING_UNIT@ )),OR(@OPERATING_UNIT (1)@ ="A",@OPERATING_UNIT (1)@ ="X",@OPERATING_UNIT (1)@ ="R")),True)

Trying to use this statement to determine if the column is filled out correctly.
So it is kicking back true for the scenario.
Labels (1)
0 Kudos
4 Replies
Highlighted
Linear Actuator
Hi there, can you please provide a little more context for your question--your specific use case will be super helpful. thank you.
0 Kudos
Image Sensor
So we have accounts which require an A - allocation, O - optional, R - Required and X -Required. So if an individual ask to create a new account in our system they need to properly place an A, O, X, R or leave blank to signify it is not needed. This would be the AAM - Account Attributed Matrix. Basically, if you are an expense account. What the user needs to fill out to have an accurate journal entry. I can do a share screen and show you. if you email me at crowj5@nationwide.com.
0 Kudos
Highlighted
NiCd Battery
The syntax for the if() statement is:

IF(CONDITION, TRUE_VALUE, FALSE_VALUE)

CONDITION is the expression you want to evaluate.
TRUE_VALUE is the value the function returns if the CONDITION is true.
FALSE_VALUE is the value that is returned if the CONDITION is not true.

If you separate your logic into separate rows, it will be easier to see

Image: https://us.v-cdn.net/6030933/uploads/editor/ym/q54qc86pc3ju.png

If your CONDITION is true, then the TRUE_VALUE will always return "TRUE", and you hardcoded the FALSE_VALUE to "True"

0 Kudos
Highlighted
DC Motor
Hello jkingcrow21,

Please try the following compute statement - if(and(or(@CHARTFIELD2 (1)@ ="X",@CHARTFIELD2 (1)@  ="R",@CHARTFIELD2 (1)@  ="A"),isblank(@CHARTFIELD2@ )),true,false)

This should work.

Thank You,
Akshay


0 Kudos