Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks,
Chris
Hi Chris, try this in the script:
Num(yorfield,'U$#.##0,00;-U$#.##0,00') as field
Hi Chris, try this in the script:
Num(yorfield,'U$#.##0,00;-U$#.##0,00') as field
Thanks Pablo, that did the trick!