Result till one decimal place (it should not be round)

[agni_gold]

Hi Friends ,

I am geeting some values like

1.47

1.478

1.96

and soo on

but i want result till one decimal place only as number format without round , like

1.4

1.4

1.9

please suggest

[aarkay29]

floor('1.478',0.1)

[agni_gold]

it is rounding my result it become 1.5

[agni_gold]

=floor( (FABS(sum({<$(v_SegSaleFilter)= {'TotTerexAerials'}, $(v_AOPDateRangeSC)> }[Target Budget])/1000000)-

FABS(sum({<$(v_SegSaleFilter)= {'TotTerexAerials'}, $(v_ACTDateRange)> }[ERP Amount USD])/1000000)),0.1)

is my expression

[sunny_talwar]

Floor is rounding 1.478 to 1.5? Can you share a screenshot of with and without floor function?

[agni_gold]

My Expression is without floor is

=(FABS(sum({<$(v_SegSaleFilter)= {'TotTerexAerials'}, $(v_AOPDateRangeSC)> }[Target Budget])/1000000)-

FABS(sum({<$(v_SegSaleFilter)= {'TotTerexAerials'}, $(v_ACTDateRange)> }[ERP Amount USD])/1000000))

result : -1.4670449445889

with floor expression

=floor( (FABS(sum({<$(v_SegSaleFilter)= {'TotTerexAerials'}, $(v_AOPDateRangeSC)> }[Target Budget])/1000000)-

FABS(sum({<$(v_SegSaleFilter)= {'TotTerexAerials'}, $(v_ACTDateRange)> }[ERP Amount USD])/1000000)),0.1)

result : -1.5

[sunny_talwar]

Its a negative number.... Try with Ceil instead of Floor

[sunny_talwar]

=Ceil( (FABS(sum({<$(v_SegSaleFilter)= {'TotTerexAerials'}, $(v_AOPDateRangeSC)> }[Target Budget])/1000000)-

FABS(sum({<$(v_SegSaleFilter)= {'TotTerexAerials'}, $(v_ACTDateRange)> }[ERP Amount USD])/1000000)),0.1)

[agni_gold]

but i need to use FABS here

[sunny_talwar]

I am not stopping you from using it

Update: fabs is still there?