Qlik Sense Desktop Money Formatting Question

[cmillerclaritas]

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

[PabloTrevisan · Accepted solution]

Hi Chris, try this in the script:

Num(yorfield,'U$#.##0,00;-U$#.##0,00') as field

[cmillerclaritas]

Thanks Pablo, that did the trick!