Skip to main content The Trailblazer Community will be unavailable from 2/1/2025 to 2/2/2025. Please plan your activities accordingly.
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)

)

)

 
2 answers
  1. Jun 2, 2015, 7:02 AM

    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

     
Loading
0/9000