web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Report issue: decimal ...
Small and medium business | Business Central, N...
Suggested Answer

Report issue: decimal places for column

(0) ShareShare
ReportReport
Posted on by Hedi Daneels 487

Hi,

We are having an issue with a new report we created. For some reason, we cannot get the decimal places right.

When we do: 

     column(aantalPlaten; aantalPlaten) { AutoFormatType =0; DecimalPlaces=0 }
or
     column(aantalPlaten; aantalPlaten) {  DecimalPlaces=0 }
The information is simply ignored. In the report, there is always 2 decimals for that one.
For some other columns/fields, we sometimes have more than 2 decimals.
Those are all fields defined in the report themselves.
Please advice.
Cheers
I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    did you check the field propery on the layout? I mean the format number

  • Hedi Daneels Profile Picture
    Hedi Daneels 487 on at

    How can you do that in word please?

  • Community Member Profile Picture
    Community Member on at

    I have not noticed that it is the Word report.

    did you try different decimalPlaces like { AutoFormatType =0; DecimalPlaces=4 } to make sure that it affects on the layout?

  • Suggested answer
    Hedi Daneels Profile Picture
    Hedi Daneels 487 on at

    Nothing worked... Except in the column, formating with:

    Format(VARNAME, 0, '<Precision,0><Standard Format,0>')

    This looks like a bug to us...

  • Suggested answer
    THE Italian Profile Picture
    THE Italian Microsoft Employee on at

    What is the version and build number you are working with?

    If this is an online version or latest 16.x build then I would suggest you to be in touch with your CSP Partner and let them open a support request through the official Microsoft channel.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 580 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 480 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 261 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans