Forum Discussion
Formula Help
- 6 years ago
erhan_79 this should be pretty straight forward, see sample attached, I created two table order and order delivered and add delivery qty into two different buckets, you can make the logic change as your model.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
i used your formula , for filter i used order number , but that formula gave me only days and seems like as below
i just wanted to find quantitites , but the new column gaves below days just , minus and positive numbers and same , i think somthing wrong , maybe i could not tell what i wanted
dear amitchandak
i just only need to calculate and find " 60 " pcs , maybe with a formula a quick measure enough for it ? system will only calculate how many pcs real delivered based on planned delivery date and before for delivery date together.