Joined: 14 Nov 2018
Online Status: Offline
Posts: 11
Posted: 30 Nov 2018 at 8:27am
If I'm understanding you correctly, yes the CUSTOMER_ORDER_JOIN.STATE field houses all of the status' we would consider 'open' and the invoiced/closed one. Do I need do I need to account for the state equaling basically anything including 'Invoiced/Closed' in the or half of my formula?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 30 Nov 2018 at 10:48am
I was thinking you were bringing in another table and that the join might have been excluding the rows you were missing. You should not need to indicate anything
to select 'All' of the status categories.
If you have NULLS in your data set you might need to to set the formula to use default values for nulls. I can't really 'picture' your full data set to give anymore advise...
I suggest you drop all the values into your detail section to visually understand your full data set to see how you need to filter.
Joined: 14 Nov 2018
Online Status: Offline
Posts: 11
Posted: 04 Dec 2018 at 8:20am
Thank you! When I looked at again I realized that it was excluding the open orders because they did not have a real ship date so I was able to rework it and pull those in. Thanks again for the help!
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
