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...
  • 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" )
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" )