Skip to main content



No record found.

Dynamics 365 Community / Forums / Finance forum / Syntax (formula help)
Finance forum
Suggested answer

Syntax (formula help)

Posted on by 9
Good morning,
I am trying to figure out how to tell my QUANTITY column and/or my REMAINING BALANCE column (Reported As Finished is the system terminology) to report when an order has packed, but not complete (i.e 62 is the order but 2 did not pack).  I'd prefer to set it up as a tile on my dashboard, but may have to use the alert to email route (I don't see a real option for setting that up either.).  I appreciate any help I can get!  Thanks!
  • DT-08051425-0 Profile Picture
    DT-08051425-0 9 on at
    Syntax (formula help)
    I think I'm close with this, but it's displaying all the NULL values instead of the NON NULL values
    ProdTable.RemainInventPhysical IS NOT NULL AND ProdTable.RemainInventPhysical<ProdTable.QtySched  
    In my picture, I don't want to see the green line item because the remaining balance is null.
    Thank you!
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Syntax (formula help)
    You can refer to this official document, hope to help you: Modify a workspace with a tile, list, and data cache - Finance & Operations | Dynamics 365 | Microsoft LearnIn this tutorial, you will create a new tile and include it in the summary section of a workspace, build a new list for a workspace, and create a data cache for the list in the workspace.
    Best regards,

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans