Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Filter out non empty field.

In the table listed below, I am trying to build a report of estimates that still need to be followed up on. If field Accepted_Est_Date has a value then the estimate no longer needs to be followed up on so I need these filtered out. I am not sure how to do this as every filter I have tried has not worked. Any ideas would be greatly appreciated.

Accepted_Estimate_date.png

1 Solution

Accepted Solutions
krishnacbe
Partner - Specialist III
Partner - Specialist III

If you want to do this in Load Script then you can create a Flag when Accepted_Est_Date is Null.

Try below expression

         if(isnull(Accepted_Est_Date) or Len(Accepted_Est_Date)=0,1,0) as Flag

In Chart use this Flag to filter when Flag is 1.

View solution in original post

3 Replies
krishnacbe
Partner - Specialist III
Partner - Specialist III

If you want to do this in Load Script then you can create a Flag when Accepted_Est_Date is Null.

Try below expression

         if(isnull(Accepted_Est_Date) or Len(Accepted_Est_Date)=0,1,0) as Flag

In Chart use this Flag to filter when Flag is 1.

Anonymous
Not applicable
Author

Thank you so much. That worked beautifully.

krishnacbe
Partner - Specialist III
Partner - Specialist III

Good to hear.

Please close the thread by marking the Correct/Helpful Answer.