I am working on the Order object and I built a formula field to bring over the Opportunity Amount onto the Order. I would like to see if I can build a formula field and Icon to show the following:
If Order amount = Opportunity amount then the Icon will be Green
If Order amount <> Opportunity amount then the Icon will be Red
Order Amount Field API: TotalAmount
Opportunity Amount Field API: Opportunity_Amount__c
Is this possible?
Thanks,
Aaron
10 件の回答
Hi Arron, try
IF(
Total_Amount__c = Opportunity.Amount,
IMAGE("/img/samples/color_green.gif", "green", 15, 15),
IMAGE("/img/samples/color_red.gif", "red", 15, 15)
)
use the formula builder to find the correct reference for the field on your related record.
The above formula assumes that Total Amount is a custom field, while the Amount field is from the standard Opportunity object.
