Formatting calculated number field

[BikeBoy]

Hi all,

I am trying to format a calculated field to only show 1 decimal point, and can't do it. I tried the regular Format->Number->Show fixed num of decimal digits, doesn't work.

The field is a simple arithmatic calc:

RelationA::F1 * LocalF1 / 1000 & " " & "kg"

It is unstored number field (since it's based on related RelationA::F1 field). Anyone had this problem before?

Thanks in advance for tips/pointers.

[Lee Smith]

At the layout level, you can change the fixed decimal to 1 instead of 2.

:??

[Pupiweb]

Your calc field has text result, so it will use the full number resulting from the numeric part of the calc.

Wrap that into a Round function:

Round (RelationA::F1 * LocalF1 / 1000,1) & " kg"

[BikeBoy]

thank you Pupiweb, I'll try that.