I have following values in db table:

1

2

3.9

4.8888

 

How to display in CR as below

1

2

3.9

4.8

 

Can anyone help with formula to show result as above..i tried but getting as

1.00

2.00

4.90

4.80

 

if (ToNumber({Energy_Transfer.kuw_A_E}) - truncate(ToNumber({Energy_Transfer.kuw_A_E}))) <> 0 then
round(Tonumber({Energy_Transfer.kuw_A_E}),1) else tonumber({Energy_Transfer.kuw_A_E})

My formula is

 

Thanks to help.