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 485

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
  • Suggested answer
    THE Italian Profile Picture
    THE Italian on at
    RE: Report issue: decimal places for column

    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.

  • Suggested answer
    Hedi Daneels Profile Picture
    Hedi Daneels 485 on at
    RE: Report issue: decimal places for column

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

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

    This looks like a bug to us...

  • Community Member Profile Picture
    Community Member on at
    RE: Report issue: decimal places for column

    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?

  • Hedi Daneels Profile Picture
    Hedi Daneels 485 on at
    RE: Report issue: decimal places for column

    How can you do that in word please?

  • Community Member Profile Picture
    Community Member on at
    RE: Report issue: decimal places for column

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

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 686

#2
YUN ZHU Profile Picture

YUN ZHU 646 Super User 2025 Season 1

#3
Mansi Soni Profile Picture

Mansi Soni 495

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans