dynamic number formating (negative numbers)

[Sofinobi]

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 · Accepted solution]

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