I am trying to calculate GMROI per item and am having trouble getting the average inventory cost.
My data is something like this:
If I try
Instead I want the 90 divided by the number of dates (3), so I'm getting an average SOH overall instead of per store.
Can anyone please help?
Go to Solution.
Create below measure and put it in card
View solution in original post
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!