Options

Decimal values not showing properly.

manishkutarmanishkutar Member Posts: 19
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.

Manish Kutar,
Senior Technical Consultant
manishkutar@gmail.com

Answers

  • Options
    krikikriki Member, Moderator Posts: 9,098
    [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.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • Options
    manishkutarmanishkutar Member Posts: 19
    I solved my problem..
    I just used: FORMAT(ABS(<Variable>),0,'<Sign><Integer><Decimals,3>')

    And i found this in help file.

    Manish Kutar,
    Senior Technical Consultant
    manishkutar@gmail.com
Sign In or Register to comment.