Is it possible to use the formula button (Format editor > tab: Number > Customize > Decimals) so that
if {rowname} = 'Players' then {Field1} is converted from 10.00 to just 10
and where {rowname} is not 'Players' then {Field1} will be displayed as 10.00
the database is passing {Field1} as numeric(15,2)
Everything i tried did not work
Thanks in advance for your help