+ Start a Discussion
Skie OcasioSkie Ocasio 

HELP: I need help with a Formula that is not working......

I am trying to create a field that deducts the "quoted amount" from the "transaction amount" only when the custom object "vendor" Vendor compnay is is Prominent Tickets.  Can someone assist me?

Quoted_Amount__c - Transaction_Amount__c && Vendor__r.Name = Prominent Tickets
Best Answer chosen by Skie Ocasio
Naresh YadavNaresh Yadav
Hi Skie

Please give it a try.

IF(Vender__r.Name == 'Prominent Tickets',Quoted_Amount__c - Transaction_Amount__c,false)

All Answers

Naresh YadavNaresh Yadav
Hi Skie

Please give it a try.

IF(Vender__r.Name == 'Prominent Tickets',Quoted_Amount__c - Transaction_Amount__c,false)
This was selected as the best answer
Skie OcasioSkie Ocasio
THANK YOU, I made some edits but it worked!!!!

IF(Vendor__r.Name =='Prominent Tickets',Quoted_Amount__c - Transaction_Amount__c,NULL)
Parker EdelmannParker Edelmann
Looks like @Naresh Yadav was able to solve your question. Could you please mark his answer as best so that it appears as solved and he gets credit for it?

Thanks,
Parker