Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Display Negative Numbers in Parenthesis

I am using a SWITCH function to format a measure.  How to display in parenthesis with no rounding.  Please help me adjust my switch function.   These negative number should be displayed like (36k),...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    1 year ago

    Anonymous

    This is the default currency format string: 

    "\$#,0.###############;(\$#,0.###############);\$#,0.###############"
     
    So try:
    SWITCH(
    TRUE(),
    ABS(_salesMeasure) > 1000000000, FORMAT(_salesMeasure, "\$#,,,.0B;(\$#,,,.0B);\$#,,,.0B"),
    ABS(_salesMeasure) > 1000000, FORMAT(_salesMeasure, "\$#,,.0M;(\$#,,.0M);\$#,,.0M"),
    ABS(_salesMeasure) > 1000, FORMAT(_salesMeasure,"\$#,K";(\$#,K);\$#,K""),
    ABS(_salesMeasure) > 0, FORMAT(_salesMeasure,"\$#;(\$#);\$#")
    )
Greg_Deckler's avatar
Greg_Deckler
Community Champion
1 year ago

Anonymous

This is the default currency format string: 

"\$#,0.###############;(\$#,0.###############);\$#,0.###############"
 
So try:
SWITCH(
TRUE(),
ABS(_salesMeasure) > 1000000000, FORMAT(_salesMeasure, "\$#,,,.0B;(\$#,,,.0B);\$#,,,.0B"),
ABS(_salesMeasure) > 1000000, FORMAT(_salesMeasure, "\$#,,.0M;(\$#,,.0M);\$#,,.0M"),
ABS(_salesMeasure) > 1000, FORMAT(_salesMeasure,"\$#,K";(\$#,K);\$#,K""),
ABS(_salesMeasure) > 0, FORMAT(_salesMeasure,"\$#;(\$#);\$#")
)
Anonymous's avatar
Anonymous
Not applicable
1 year ago

How do I stop the -999.97 from rounding to ($1000)?  It should format to (.999)