I am trying to figure out why the Excel extract details don't come out correctly. I have two files that I have joined and I'm trying to calculate the number of units for each plant. There are 2 plants (11 and 13).
When I write the set analysis expression for plant 11, I do get the correct number which is supposed to be 7. However, when I extract the Excel report, I only see 6 units for plant 11.
Can someone explain how I would need to write my script such that the KPI output matches the Excel extract. ( I should note that two rows on the Excel table have identical data (Plant=11, Lines=1, Units=7)