function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Naveen KvpNaveen Kvp 

Validation on Tax Master

Hi Friends

Validation:In Tax Master i have a Three fields Excise duty,Vat And Cst if we fill Excise duty either Vat or Cst only one should enter.

How to write a validation for this please provoide some inputs,Thanks in advance.

i am writing a Validation like this but it won't work: 
AND( 
ISBLANK( Excise_Duty__c ), 
OR( 
NOT(ISBLANK(VAT__c)), 
ISBLANK(CST__c) 
), 
OR( 
NOT(ISBLANK(CST__c)), 
ISBLANK(VAT__c) 
) 
)

 
Amit TrivediAmit Trivedi
Hi Naveen ,

As per your requirement,I think the below validation rule will work try and let me know in case of issue
(NOT(ISBLANK(Excise_Duty__c))) && (NOT(ISBLANK(CST__c)) && NOT(ISBLANK(VAT__c)))

Thanks,
Amit Trivedi
Amit Chaudhary 8Amit Chaudhary 8
Please try below validarion 
AND(
      NOT( ISBLANK( Excise_Duty__c ) ),
      AND ( NOT ( ISBLANK( VAT__c )),
                  NOT ( ISBLANK( CST__c ))
           )
)
Please let us know if this will help you