Microsoft Dynamics NAV (Archived)

How to set the amount into 2 Decimal Places

(0) Share

Report

Posted on by Jade Ng

227

Hi everyone,

I have encounter one problem which is i don't know how to set the amount into 2 decimal places in report layout.

2047.capture2.png

My problem is how to make the highlighted amount(yellow color) into 2 decimal places same as the amount decimal (red box)? For the first column, line amount column, it able to generate 176.00. So, there is no problem for the decimal places.

But on the other hands, when there is zero amount in the 2nd column and 3rd column, the decimal places will not shown in 2 decimal places.

So, where i should make changes and set it as 2 decimal places.

Thanks.

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Suresh Kulla 44,507 on at

Like (0)

Report

RE: How to set the amount into 2 Decimal Places

You can set the expression as

=Format(Fields!abc.Value,"F2")
Suggested answer

Teddy Herryanto (Th... 13,019 Moderator on at

Like (0)

Report

RE: How to set the amount into 2 Decimal Places

If you are talking about report, in the layout section, click the field and there should be a property called Format. You can assign it with a field (format.value field) or write a fixed format yourself.
Suggested answer

Binesh 7,885 on at

Like (0)

Report

RE: How to set the amount into 2 Decimal Places

Go to the Report Designer.

Select the field, right click on field.

Choose TextBox Property

Now choose Number from left side pannel and then choose your the formating what you want.

After OK, save/compile and run the report.