Is it possible to format a number on the following condition:
if {rawname} = 'Alfa' then {amount} without decimals
else with decimals
rawname amount
alfa 1
gamma 1.00
beta 12.76
sql database is passing numeric(15,2).
rawname is a string
amount is a number
i tried several formulas and nothing worked as expected. i'd like to handle that using (Format Field > Tab: Number > Customize.. > Decimals and click on the formula button)
i used a similar method to control the font, ie
if {rawname} = 'alfa' then crBold
else crRed;
and this worked.
thanks so much in advanced.