• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Finding Out Percent of Lines Open...

ahusain

New Member
This should be a very fairly easy question but for some reason, I cannot seem you process it in mind and cannot seem to find a proper search in google...
I am trying to find out what percentage of LINES and VALUES$ for Open orders THAT has a valid ship date and which one has a blank ship date.

Can someone please assist?
 

Attachments

  • OPENORDER.xlsx
    10 KB · Views: 4
This should be a very fairly easy question but for some reason, I cannot seem you process it in mind and cannot seem to find a proper search in google...
I am trying to find out what percentage of LINES and VALUES$ for Open orders THAT has a valid ship date and which one has a blank ship date.

Can someone please assist?
Is this what you want?
 

Attachments

  • OPENORDER.xlsx
    12.6 KB · Views: 3
Thank you.... is it doable to perform the function for the field "Date Due to Stock" to find out the percentage that has dates and percentage that has no dates listed?
 
Back
Top