By using this website, you agree to our Terms of Use (click here)
I want to know the monthly average Qty on Hand of an item, which would be calculated as:
Sum(Qty on Hand for each day in month) / Number of days in the month
Does this require a BI tool or can it be done in GI?
I could do it if I had a table which exploded each financial period in to each day of the month, but I don't think such table exists.
This is definitely the kind of thing that something like Power BI would be good at.
There is the DateInfo Data Access Class, but that is only for a calendar year and has no column for the Financial Period.
There is the FinPeriod Data Access Class, but that only has a column for the Start Date and End Date, not a separate row for each date.
What about doing a SQL View using this method (click here) and then feeding the SQL View into a Generic Inquiry?
Online Members
