Formating Help 1

[fmrock]

I am trying to concate 2 fields and display to the user in one column.

{table.Oxygen} & " (" & {table.OxygenPct} * 100 & "%)"

However, no matter what i have tried, the percentage allways has 2 decimals.

We have tried, Round, Truncate, and Int.

The result should look like "2 (100%)"

Any help would be great.

 

[TheBlondOne]

Try this

{table.Oxygen} & " (" & totext({table.OxygenPct} * 100,0) & "%)"

HTH

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )