Forum Discussion

edubcardoso's avatar
edubcardoso
Icon for Advocate I rankAdvocate I
3 years ago
Solved

automatically switch to M or K - Table

Hello everyone!   Maybe this is just a stupid question, but i cant figure it out. I know in the Card view, we can set Auto in Display Units | Callout Value But in Table view that option doesnt ex...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    3 years ago

    edubcardoso , Try something like,

     

    SWITCH ( TRUE() ,
    [Value] >= 1000000000 , CONCATENATE("$", FORMAT ([M1]/1000000000, "#,###.0") & "bn") ,
    [Value] >= 1000000, CONCATENATE("$", FORMAT (COALESCE([M1], 0)/1000000, "#,###.0" )& "M") ,
    [Value] >= 1000, CONCATENATE("$", FORMAT (COALESCE([M1], 0)/1000000, "#,###.0" )& "K") ,
    CONCATENATE("$", FORMAT (COALESCE([M1], 0) , "#,###.0")
    ))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

edubcardoso , Try something like,

 

SWITCH ( TRUE() ,
[Value] >= 1000000000 , CONCATENATE("$", FORMAT ([M1]/1000000000, "#,###.0") & "bn") ,
[Value] >= 1000000, CONCATENATE("$", FORMAT (COALESCE([M1], 0)/1000000, "#,###.0" )& "M") ,
[Value] >= 1000, CONCATENATE("$", FORMAT (COALESCE([M1], 0)/1000000, "#,###.0" )& "K") ,
CONCATENATE("$", FORMAT (COALESCE([M1], 0) , "#,###.0")
))