I have start and end date for an event. I would like to find what the mid point time period between these dates is.
Is there a formula I can use to do that?
Hi @RoopaliB ,
You can create a number formatted line item for mid point between the dates ( i.e. (End date - Start date)/2) and add this to the start date to get mid date.
Please find the snapshots below
Hope this helps.
Thanks
Hi @Jitendra.Vishnolia
This works. Thanks!
XL3SetProperty to navigate
Hi, Where are the member properties for lists defined in Anaplan XL? In the training documentation there is an example showing a property such as “Birth Date”, which appears to be a list-item attribute. That suggests you can create custom list properties from the Anaplan list. However, when I connect through Anaplan XL, I…
Hi all I have a list of networks organized hierarchically on a list of entities, which is itself organized hierarchically on a list of divisions (organization). An entity can have several networks. I also have a list of product models, which is itself ranked with three higher levels: this “Models” L4 list is ranked at a…
