Skip to Content
avatar image
Former Member

re: validations in MDM

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 04, 2008 at 06:03 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Sep 04, 2008 at 05:41 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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