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

Notifications

Announcements

No record found.

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 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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,151

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,443 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans