Joined: 24 Dec 2017
Location: United States
Online Status: Offline
Posts: 6
Topic: Format specific values in the column. Posted: 09 Feb 2018 at 9:55am
I'm trying to format specific values in the same column of crystal report.
The column should show all the other numbers as decimals, except for 100. 100 should be shown as a whole number.
This is what I did.
In format field, Number tab, customize, For Decimal I entered following formula;
If {@Numeric2} = 100 Then 1 Else 1.0
The problem is that it is not rounding 100 as a whole, instead, showing 100 as a decimal as well like 100.0
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 12 Feb 2018 at 2:43am
right click on the field
select format field
select number tab
select customize button
select the formula (x+2) for Decimals
use
if currentfieldvalue = 100 then 0 else 1
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
