The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

emantziaris's avatar
emantziaris
New Contributor
1 year ago

Cube Views: Taking Date from an Entity Dimension Text Field to Calculate Months to Date

I am trying to calculate months to date in a cube view column based on a date entered in a text field within Entity Dimension members. The text field would display in one of the columns on the cube v...
Cube View
dashboards
Reports
emantziaris's avatar
emantziaris
New Contributor
1 year ago

Thank you for the message! I am looking to convert this date to a calculation of months between the current date (today) and the date that is displayed in the text field. 

pranav46's avatar
pranav46
Contributor III
1 year ago

Member formula you got to write a vb code. 

Get the text value from Entity then you write your logic to calc month diff between current date to Text

Dim EntityText As String = api.Account.Text(api.Pov.Entity.MemberId,1)