+ Start a Discussion
sanjdevsanjdev 

Help required for validation rule Urgent

Atleast one field should have value out of 5 field and the value should be greater and equal to 0 .

 

I have tried with the below, it works for (Atleast one field should have value out of 5 field) but could not able to validate to have value > 0. All field are Number type.

 

AND(
AND(ISBLANK(Akreos_MI_60__c),ISNULL(Akreos_MI_60__c)),
AND(ISBLANK(Akreos_AO__c),ISNULL(Akreos_AO__c)),
AND(ISBLANK(Akreos_Adapt__c),ISNULL(Akreos_Adapt__c)),
AND(ISBLANK(Envista__c) ,ISNULL(Envista__c) ),
AND(ISBLANK(LI61_AO__c ),ISNULL(LI61_AO__c )),
AND(ISBLANK(LI61_SE__c) ,ISNULL(LI61_SE__c)),
AND(ISBLANK(Crystalens__c ),ISNULL(Crystalens__c )),
AND( $RecordType.Name ='INDSU Sales Planned')
)

 

 

Best Answer chosen by Admin (Salesforce Developers) 
Navatar_DbSupNavatar_DbSup

Hi,

Try the below formula:

 

AND(

AND(ISBLANK(Akreos_MI_60__c),ISNULL(Akreos_MI_60__c)),

AND(ISBLANK(Akreos_AO__c),ISNULL(Akreos_AO__c)),

AND(ISBLANK(Akreos_Adapt__c),ISNULL(Akreos_Adapt__c)),

AND(ISBLANK(Envista__c) ,ISNULL(Envista__c) ),

AND(ISBLANK(LI61_AO__c ),ISNULL(LI61_AO__c )),

AND(ISBLANK(LI61_SE__c) ,ISNULL(LI61_SE__c)),

AND(ISBLANK(Crystalens__c ),ISNULL(Crystalens__c )),

AND(OR(Akreos_MI_60__c > 0 ,Akreos_AO__c > 0,Akreos_Adapt__c > 0,Envista__c > 0,LI61_AO__c > 0,LI61_SE__c > 0))

AND( $RecordType.Name ='INDSU Sales Planned')

)

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 

All Answers

Navatar_DbSupNavatar_DbSup

Hi,

Try the below formula:

 

AND(

AND(ISBLANK(Akreos_MI_60__c),ISNULL(Akreos_MI_60__c)),

AND(ISBLANK(Akreos_AO__c),ISNULL(Akreos_AO__c)),

AND(ISBLANK(Akreos_Adapt__c),ISNULL(Akreos_Adapt__c)),

AND(ISBLANK(Envista__c) ,ISNULL(Envista__c) ),

AND(ISBLANK(LI61_AO__c ),ISNULL(LI61_AO__c )),

AND(ISBLANK(LI61_SE__c) ,ISNULL(LI61_SE__c)),

AND(ISBLANK(Crystalens__c ),ISNULL(Crystalens__c )),

AND(OR(Akreos_MI_60__c > 0 ,Akreos_AO__c > 0,Akreos_Adapt__c > 0,Envista__c > 0,LI61_AO__c > 0,LI61_SE__c > 0))

AND( $RecordType.Name ='INDSU Sales Planned')

)

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 

This was selected as the best answer
sanjdevsanjdev

Hi ,

 

Thanks for help.

 

Sanj