Forum Discussion

Sofinobi's avatar
Sofinobi
Icon for Helper IV rankHelper IV
3 years ago
Solved

dynamic number formating (negative numbers)

good morning all,

 

i have a code formating for numbers, it's ok, but i need the same part for the negative numbers, please how can i perform that


VAR salesMeasure = [Sales]
return SWITCH(TRUE(),
 salesMeasure<10000,"#,0",
 salesMeasure<1000000, "#,.00 K",
 salesMeasure<1000000000, "#,,.00 M" ,  
 salesMeasure>=1000000000, "#,,,.00 B")

thank you
  • Sofinobi's avatar
    Sofinobi
    3 years ago

    i find the solution by modifiying the code like this, i'll keep the post for other members,

     
    VAR salesMeasure = [Sales]
    return SWITCH(TRUE(),
     salesMeasure>=1000000000, "#,,,.00 B",
     salesMeasure>=1000000, "#,,.00 M" ,
     salesMeasure>=10000, "#,.00 K",
     salesMeasure>=0,"#,0",
     salesMeasure>-10000,"#,0",
     salesMeasure>-1000000, "#,.00 K",
     salesMeasure>-1000000000, "#,,.00 M" )

1 Reply

  • Sofinobi's avatar
    Sofinobi
    Icon for Helper IV rankHelper IV
    3 years ago

    i find the solution by modifiying the code like this, i'll keep the post for other members,

     
    VAR salesMeasure = [Sales]
    return SWITCH(TRUE(),
     salesMeasure>=1000000000, "#,,,.00 B",
     salesMeasure>=1000000, "#,,.00 M" ,
     salesMeasure>=10000, "#,.00 K",
     salesMeasure>=0,"#,0",
     salesMeasure>-10000,"#,0",
     salesMeasure>-1000000, "#,.00 K",
     salesMeasure>-1000000000, "#,,.00 M" )