Stop Format Function from Rounding

[sa34techer]

Can I stop the FORMAT function from rounding up?  Please see my code below.

Measure =

var _salesMeasure =

[Measure]

var _result =

SWITCH(

TRUE(),

ABS(_salesMeasure) > 1000000000, FORMAT(_salesMeasure, "\$#,,,.0B;(\$#,,,.0B)"),

ABS(_salesMeasure) > 1000000, FORMAT(_salesMeasure, "\$#,,.0M;(\$#,,.0M)"),

ABS(_salesMeasure) > 1000, FORMAT(_salesMeasure,"\$#,K;(\$#,K);(\$#,K"),

ABS(_salesMeasure) > 0, FORMAT(_salesMeasure,"\$#;(\$#)")

)

RETURN

_result

[rajendraongole1 · Accepted solution]

Hi @sa34techer -  To prevent rounding, you can modify your logic to handle the formatting conditionally without using FORMAT for precise values (e.g., numbers below a certain threshold).

try the updated version of measure:

Measure =
VAR _salesMeasure = [Measure]
VAR _result =
SWITCH(
TRUE(),
ABS(_salesMeasure) > 1000000000, FORMAT(_salesMeasure, "\$#,,,.0B;(\$#,,,.0B)"),
ABS(_salesMeasure) > 1000000, FORMAT(_salesMeasure, "\$#,,.0M;(\$#,,.0M)"),
ABS(_salesMeasure) > 1000, FORMAT(DIVIDE(_salesMeasure, 1000, 0), "\$#K;(\$#K)"),
ABS(_salesMeasure) > 0, FORMAT(_salesMeasure, "\$#,##0.00;(\$#,##0.00)")
)
RETURN
_result

check the above and let me know.