on 09-08-2011 1:27 PM
Hi all,
I have created validations inside a tuple(multivalued).
I am not getting the results as expected.
1. can validations be performed on multivalued tuples....... are there any restrictions
2. I have 3 fields in tuple (division, phone 1, ext), my requirement is that if PHONE or EXT is not null, DIVISION is not null,
IF (IS NOT NULL(PHONE or EXT ), IS NOT NULL(DIVISION))
if I give only PHONE value and execute, the validation throws error..... works fine.
if I give only EXT, says no validation error.
pls guide me.
rgds,
ve
Thanks for your quick replies............ its working now.
rgds,
ve.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Veena,
Try this :
IF(Is Not Null(Phone),Is Not Null(Division),IF(Is Not Null(Ext),Is Not Null(Division)))
Flow goes like If Phone is not null Division should not be null,and when Phone is null it checks if Ext is null in the Else part of expression.If Ext is not Null it imposes Division to be not null.
Hope it helps.
Thanks,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Veena,
Firstly, your expression is not correct, please use the below expression
IF (IS_NOT_NULL(PHONE) OR IS_NOT_NULL(EXT ), IS_NOT_NULL(DIVISION))
Kindly revert with result.
Regards,
Mandeep Saini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.