re: validations in MDM

[Former Member]

I want the industry key to given for only account groups=a/b/c/d

Els if the account grp is other than a/b/c/d it should not accept industry key value.

I have written it as

IF((account group .Name(Not equals Symbol<>) Account group[a] or

account group .Name(Not equals Symbol<>) Account group<b> or

account group .Name(Not equals Symbol<>) Account group[c] or

account group .Name (Not equals Symbol<>) Account group[d] ),IS_NULL(Industry.[Record]))

This is working fine for the other account groups than a/b/c/d if the industry key value is given it is throwing error.......but the same with account groups a/b/c/d..but i want the account groups a/b/c/d to accept the industry key value.

Edited by: shifali charya on Sep 4, 2008 7:38 AM

Edited by: shifali charya on Sep 4, 2008 7:39 AM

Edited by: shifali charya on Sep 4, 2008 7:39 AM

[Former Member · Accepted solution]

Hi,

Just give a try

((account group .Name(Not equals Symbol) Account group[a] or

account group .Name(Not equals Symbol) Account group<b> or

account group .Name(Not equals Symbol) Account group[c] or

account group .Name (Not equals Symbol) Account group[d] ) AND IS_NULL(Industry.Record))

Regards'

Nisha

[Former Member · Accepted solution]

Hi nisha

This is working fine as throwing error if acount group is other than a/b/c/d

But i also want the feature as to accept the industry key value for the account groups a/b/c/d(Which is not being done)

[Former Member · Accepted solution]

Hi Shifali,

I tried the expression I have mentioned and it is working according to the requirement you have specified.

Please check at least once and update us.

Regards,

Jitesh Talreja

[Former Member · Accepted solution]

i tried it it is throwing error if i try to give value to account group a/b/c/d

[Former Member · Accepted solution]

Hi,

Try this,

IF((account group .Name = Account group[a] or

account group .Name = Account group(b) or

account group .Name = Account group[c] or

account group .Name = Account group[d]) , IS_NOT_NULL(Industry.Record) OR IS_NULL (Industry.Record) , IS_NULL (Industry.Record))

It should work....

Thanks,

Mandeep

[Former Member · Accepted solution]

Hi Shifali,

Check the below expression.

Account Group is the lookup field in the main table

Account Groups is the lookup table

IF( (Account Group[Record] = Account Groups [a] OR Account Group[Record] = Account Groups <b> OR Account Group[Record] = Account Groups [c] OR Account Group[Record] = Account Groups [d] ) , IS_NOT_NULL(Industry.Record) OR IS_NULL (Industry.Record) , IS_NULL (Industry.Record) )

Note: Select everything from the list. Don't type anything by own

Regards,

Jitesh Talreja

[Former Member]

Hi Shifali,

Check the below expression

IF((account group .Name Account group[a] or

account group .Name Account group or

account group .Name Account group[c] or

account group .Name Account group[d] ) AND IS_NOT_NULL(Industry.Record))

Validation automatically returns True or False. In above expression it is checking that if account group is any one of the mentioned group and Industry.Record is not null then only Validation returns TRUE else FALSE.

Regards,

Jitesh Talreja

[Former Member]

NoNo...

For a/b/c/d the industry key value is Optional,they may or may not give........

But for all other than a/b/c/d no Industry key i.e it should not accept industry key

[Former Member]

Hi Shifali,

Try this one

IF( (account group .Name Account group[a] or

account group .Name Account group or

account group .Name Account group[c] or

account group .Name Account group[d] ) , IS_NOT_NULL(Industry.Record) OR IS_NULL (Industry.Record) , IS_NULL (Industry.Record) )

Regards,

Jitesh Talreja