Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Thank you so much. That worked beautifully.
Good to hear.
Please close the thread by marking the Correct/Helpful Answer.