Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

excel cell format in d365fo using x++

(0) ShareShare
ReportReport
Posted on by

pastedimage1681275436754v1.png 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

  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    RE: excel cell format in d365fo using x++

    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.

  • Suggested answer
    Komi Siabi Profile Picture
    Komi Siabi 12,759 Most Valuable Professional on at
    RE: excel cell format in d365fo using x++

    Hello, 

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

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans