Forum Discussion
Thinking to create a member with formula (Hope you have UD8 dim empty even if you dont have its okay to use dim based on your app) to read text value of entity, convert into date & display in Cubeview.
In the cube view you need to bring a new member which will have formula and view member which is annotation type.
Below example is hardcoded but I am reading an account and disapplying 01/01/25
- emantziaris7 months agoNew Contributor
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.
- pranav467 months agoContributor II
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)
Related Content
- 2 years ago
- 2 years ago
- 7 months ago
- 2 years ago