Forum Discussion

emantziaris's avatar
emantziaris
New Contributor
8 months 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
8 months 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 II
8 months 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)