OneStream Community

BenEppel · 04-26-2023

Hello, I was wondering if anyone has had any success using Trailing3MonthAvg View member within a data buffer when the trailing 3 months cross over years. When I run this for a period like June everything works great, but when I run this in Jan or Fe...

BenEppel · 12-27-2022

Hello, I was wondering if anyone has been able to get a table view to refresh using VBA. I have tried the below code with no luck. Sub RefreshXFFunctions() Set XFAddIn = Application.COMAddIns("OneStreamExcelAddIn")If Not XFAddIn Is Nothing ThenIf Not...

BenEppel · 05-16-2023

I ended up doing something very similar! I added logic to manually calculate the average for only the time periods that cross years. If Not monthNumber = "2" And Not monthNumber = "3" Then Dim startingdb As String = "Cb#XXXXXX:T#" & TimePrior & ":A#"...

BenEppel · 04-26-2023

The version is 7.2.2. We already have plans to upgrade shortly so that works out. Thank you for the response!!

BenEppel · 12-28-2022

Thank you for the suggestions! I submitted the request here https://community.onestreamsoftware.com/t5/Productivity/Table-View-VBA-Refresh/idi-p/14776#M266

OneStream Community

User Statistics

User Activity

Using the Trailing3MonthAvg View Member in a Data Buffer Across Years

Table View VBA Refresh

Re: Using the Trailing3MonthAvg View Member in a Data Buffer Across Years

Re: Using the Trailing3MonthAvg View Member in a Data Buffer Across Years

Re: Table View VBA Refresh