Daily Average Calc
Does anyone know how to write a formula that calculates an average based on the POV's number of days? Thanks
Forum Discussion
Dim timId as Integer = BrApi.Finance.Members.GetMemberId(si, DimTypeId.Id, “2023M1”)
Dim numDays = BrApi.Finance.Time.GetNumDaysInTimePeriod(si, timId)
Dim timId as Integer = api.Members.GetMemberId(DimTypeId.time, “2023”)
Dim numDays as Integer = api.Time.GetNumDaysInTimePeriod(timeId)
Also remember to factor into V#QTD and V#YTD in your rule or member formula.