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,093 Most Valuable Professional on at

Like (0)

Report

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

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

Martin Dráb 704 Most Valuable Professional

#2

André Arnaud de Cal... 570 Super User 2025 Season 2

#3

BillurSamdancioglu 408 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans