Decimal formats varying in table and card visuals

[Juan_Quikin5]

Hi guys!

I have the regional settings of my current file in "English (United States)."  However, the auto-display units in my visual card are not matching the format of the following measure for a table visual:

SellOut = 
VAR calc = [MGMV]
var decimals = "0.0"
RETURN
    SWITCH ( TRUE() ,
        calc > 1000000 , FORMAT ( calc / 1000000 , "$" & decimals & "M" ) ,
        calc > 1000 , FORMAT ( calc / 1000 , "$" & decimals & "K" ) ,
        FORMAT ( calc , "$" & decimals )
    )

 

The card takes a comma as a decimal separator while the table takes a dot as a decimal separator.

I tried changing the "VAR decimals" part to "0,0", but this format is adding a zero to left whenever the value has just one digit (e.g. $06K)

Any idea would be very appreciated! Thanks guys!

[FreemanZ]

hi @Juan_Quikin5 

try to replace "0.0" with "#.#"

[Juan_Quikin5]

Hi @FreemanZ, I tried it but I get the same result as "0.0". 😕