Forum Discussion
Average per multiple columns
- In this scenario, I am trying to use the average from column "ABC Bid per KGs" per column "Route" and column "Weight Range".
- I want to take the average from ABC Bid per KGS and apply it to the rows where ABC Company Bid = "N".
- For the rows where ABC Company Bid = Y and are the same Route and Same Weight Range I want the average.
- Then take this average where ABC Company Bid = "Y" and apply to the rows where ABC Company Bid = "N" for the same Route and same Weight Range.
- Goal of comparing the winning rate to average rate to see how the rates would have compared if bid upon.
- IE - apply average rate of $8.62 to any row where Route is the same and Weight Range is the same. Order # 7, 11, 16, etc
- IE - apply average rate of $4.31 to any row where Route is the same and Weight Range is the same. Order # 3, 8, 10
No Replies