03-25-2022 10:20 AM - edited 03-25-2022 10:27 AM
Efficiency Measure: Inventory period is a measure of the average number of days inventory is held. Formula: Average Inventory/ (Annual COGS/365) or
365/ Inventory Turnover
'Calculate Inventory Period
'Formula: Average Inventory/ (Annual COGS/365) or
365/ Inventory Turnover
Return api.Data.GetDataCell("Divide(365, A#[YourInventoryTurnoverAccount])")
Source: Snippet Editor: Finance - Common Accounts - Efficiency Measures