This is a bit complex-but I'll try to simplify.
"Transaction" object has a Custom Currency Formula Field "Amount Outstanding" Child object "Payment" has a Status pick list field.
I want my Process on the Payment object to run when the following is true.
Payment.Status = X AND Transaction.Amount_Outstanding > 0
If that fires, then do a field update.
This of course fails, because you can't use a Formula field as the criteria for a process unless it displays True or False.
SO HOW DO I SOLVE THIS?
The problem of course is that currency formula field.
It is a IF Statement so it either displays 0 or it displays the difference between two standard currency fields.
(TotalAmount- TotalRefundAmount) - PaymentAmount + OverPaymentAmount )
(Those Amount fields are a mixture of Currency, Roll-Up and Formula fields) Is there an easier way to accomplish this OTHER than doing a new Workflow/Process on the Transaction object to do a field update on a new field with the above formula for the syntax?