Forum Discussion
sum absolute value totals based on groups
Hello everyone, How do you sum the total of the absolute difference of sub groups of records? I'm grouping SKUs by their Group_ID and I want to compare the absolute change between two forecast s...
Here are the key relationships. There are others I've cropped out for simplicity sake.
I want to be able to filter by snapshot date, business, Group, and time horizon so I have lookup tables for each.
I use the date table to reference the forecast month for forecast 1 and forecast 2, not their snapshot date.
Hi guys, I am facing the same issue. Have you achieved the expected result?