N ABC Analysis how is the Usage Qty and Historical Calculated. I am doing ABC based on Historical Annual Usage but the Usage Qty and History are the same and they appear to be only the current year.
*This post is locked for comments
N ABC Analysis how is the Usage Qty and Historical Calculated. I am doing ABC based on Historical Annual Usage but the Usage Qty and History are the same and they appear to be only the current year.
*This post is locked for comments
Usage Qty is a category with Historical, Projected and Weighted Average underneath it so I'm a little confused by your question.
From the help file
Historical Usage
Annual usage quantity is calculated from the last completed month or period plus all previous months or periods for the previous one year of sales and dependent usage (except current); or, all available information if a full year of information isn’t available. If no usage exists, the default value is zero.
I hope this helps. You can also search for ABC Analysis and pick Calculations under the results.
Mark
André Arnaud de Cal...
292,865
Super User 2025 Season 1
Martin Dráb
231,723
Most Valuable Professional
nmaenpaa
101,156
Moderator