I thought I had this solved but testing proved otherwise. I am trying to do an average of three days of pricing indexes for cargo voyages (1 day previous to the voyage, the voyage day, and 1 day post voyage). The issue I am having is that my voyage dates do not always line up with the dates that the index is published (there is no pricing info published on weekends/holidays). So I may have a list that looks like this:
If I have a voyage that takes place on 12/26, I would just use the pricing for 12/23, 12/24, and 1/2 for the appropriate index. In Excel I just use an INDEX MATCH MATCH with an approximate match instead of an exact match so my 12/26 voyage will return as 12/24 for the average calculation.
How can I reproduce this in Alteryx?
Solved! Go to Solution.
Hello @johneodell,
Would this help?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
Thanks @afv2688
That would work if I were entering the dates one at a time but I'm matching an entire month's data at once.
Hello @johneodell ,
This should work now
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
@afv2688 ,
Thank you so much!! I noticed that dates with an exact match weren't calculating correctly so I had to change the filter from Diff = 0 to Diff <= 0, but other than that, this workflow accomplished what I needed. Thank you so much for you expertise and help! Greatly appreciated!