Decimal values not showing properly.

manishkutar

Hi to all,
I am new to Navision and I am creating a report which requires to show following:
I have taken decimal variable and it is also having negative values. So, in text field i am showing it with
FORMAT(ABS(<Variable>)). So due to this, I not getting value properly as required.
For example:
If decimal value is 100.50
Then it is showing as 100.5
So how can i get 100.50 without showing Negative value.

I am using FORMAT() because I am also displaying other variables with different data types and ABS() for not showing negative values.

kriki

[Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]

Don't use FORMAT in the SourceExpression. But use property "DecimalPlaces" of the field. It should have 2:2 as value.

manishkutar

I solved my problem..
I just used: FORMAT(ABS(<Variable>),0,'<Sign><Integer><Decimals,3>')

And i found this in help file.