Hey guys, Im trying to get only fully committed tr...
# generali
Isabella
11/09/2021, 5:45 PMHey guys, Im trying to get only fully committed transactions to display on this search, I have this formula on my results to tell me if it is committed or not, but I dont know how to append it so the results to not include anything that isn't fully committed... any thoughts? --------------- Case when (ABS({quantity})-nvl({quantitycommitted},0)) = 0 then 'Fully Committed' else 'Not fully committed' end
k
KevinJ of Kansas
11/09/2021, 9:35 PMUnfortunately, I'm guessing you want line data on your search right?
KevinJ of Kansas
11/09/2021, 9:35 PMMeaning, you don't just want to see the wholly committed orders, but the actual items on them
i
Isabella
11/09/2021, 11:27 PMactually just the orders is fine, the actual items we dont worry about, the shippers can click into the orders at that point
k
KevinJ of Kansas
11/09/2021, 11:31 PMThen use that as a summary criteria with a sum equal to setup and pull your line details out of the order
KevinJ of Kansas
11/09/2021, 11:32 PM0 if it's fully committed, 1 if not, your goal is zero
i
Isabella
11/09/2021, 11:50 PMI dont even know how to do that. I feel like I should but man, this is evading me right now.
Isabella
11/09/2021, 11:51 PMmessage has been deleted
Isabella
11/09/2021, 11:51 PMlike that Im guessing?
Isabella
11/09/2021, 11:53 PMI switched it forumula numeric and then as a sum but then it broke when I ran the report with the invalid expression error
k
KevinJ of Kansas
11/10/2021, 2:23 PMCase when (ABS({quantity})-nvl({quantitycommitted},0)) = 0 then 0 else 1 endi
Isabella
11/10/2021, 4:26 PMOh! Thank you! I'm still working on my formulas, not the best at them yet. I really appreciate your help.