All, I'm trying to format a master field as money and take into account the fact that the field could have positive and negative values. I've checked the documentation but can't find a specific example of this.
How do I combine formatting for positive and negative numbers in the same formatting function? Or is there a different way to go about this? Specific example would be appreciated - format a sum of revenue to look like this: $1,000,000 or $ -$1,000,000 in one formatting function statement.