how to write the validation rule for the below code [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? Add details and clarify the problem by editing this post.

Closed 8 years ago.

if(advance__c !=null){
  amount__c + Tax_Amount__c;
}
else{
  (amount__c + Tax_Amount__c)-advance__c;
}

What exactly you are looking for?
– SFDC Learner
Commented Dec 15, 2016 at 12:35 — SFDC Learner, Commented Dec 15, 2016 at 12:35
Do you mean a formula field ?
– coderdecoder
Commented Dec 15, 2016 at 12:36 — coderdecoder, Commented Dec 15, 2016 at 12:36

coderdecoder · Accepted Answer · 2016-12-15 12:38:04Z

1

It seems like you are looking for a formula field. Create a formula field of type number and use this formula

IF(ISNULL( advance__c ) , (amount__c + Tax_Amount__c)-advance__c, amount__c + Tax_Amount__c)

answered Dec 15, 2016 at 12:38

coderdecoder

15610 bronze badges

Add a comment |

o-lexi · Accepted Answer · 2016-12-15 16:41:58Z

0

amount__c + Tax_Amount__c - NULLVALUE(advance__c, 0)

answered Dec 15, 2016 at 16:41

o-lexi

3,10215 silver badges21 bronze badges

Add a comment |

2 Answers 2