web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... excel cell format in d...

Finance | Project Operations, Human Resources, ...

Suggested Answer

excel cell format in d365fo using x++

(0) Share

Report

Report

Posted on by Sachin Mittal

2

here in second column value is coming zero , how to set it using x++ so it shows only non zero values

cell = null;
cell = cells.get_Item(currentRow, 11);
cell.set_Value(-1*vendSettlement.SettleAmountMST); its the code for column cells

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Komi Siabi 13,190 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello,

SettleAmountMST field is of type real, the default value when empty is 0.

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

You cannot show null values altogether for an int or real type field. If value is null as Komi suggested, it will be 0 or 0.0 based on the type. If it is a string, then null means empty string can be shown.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 509 Super User 2026 Season 1

#2

Giorgio Bonacorsi 375

#3

Adis 268 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans