Compare two numerical contact / custom object records
We're looking for a solution to compare two numerical values for campaign / program workflow routing. Use case is: let's say the campaign success metric is an account balance (bank checking account) increases by $1000 from the start of the campaign to some decision step along the way. If we have two numerical fields -- Balance Start & Balance End -- how can we compare the two values to determine if the Balance End is greater than Balance Start, or preferably if Balance End minus Balance Start is greater than 1000.
There are cloud apps to determine if two fields are identical but can't find any with a greater than / less than comparison operator option.
Tagged:
0