Formula for Trimming numeric fields 1

[harley1d]

Using the following formula, How do I get this to only display the whole number if there is a "0" after the decimial point instead of a number? Example: if the formula return 18.5 this is ok but if it returns 18.0 I would like the 0 to be suppressed or trimmed.

Sum ({@Transfer}) % DistinctCount ({HSP_ACCOUNT.HSP_ACCOUNT_ID})

I tried using TRIMRIGHT but since this is a number field it isn't working.

 

[kskid]

Right click on the field->Format Object and click on the number tab and select the decimal option you want.

 

[synapsevampire]

That's an odd request, as it goes against what most people like to see.

If you only want one digit of precision, here's a quick cheat:

Go into the decimals formula (Right click the number, select format field-Number->Customize->X 2 next to decimals) and use something like:

if remainder({table.field},int({table.field})) > 0 then
1
else
0

-k