Daily Average Calc

marisolbritton
New Contributor III

Does anyone know how to write a formula that calculates an average based on the POV's number of days? Thanks

3 REPLIES 3

ChristianW
Valued Contributor

you can access the number of days like this:

BrApi.Finance.Time.GetNumDaysInTimePeriod(si, timeId)

or in a finance business rule or member formula:

api.Time.GetNumDaysInTimePeriod(timeId)

Thanks Christian!  Do you happen to have a sample?  Thanks in advance

 

 

 

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)

 

 

Please sign in! marisolbritton