Hi,
We are currently have a module that is dimensioned by a list of dates. Trying to figure out what is the best formula to use to bring List data in as a date for a LI.
Hi @neg177 Firstly if you have the list of dates in text formatted in any line item then you can use below way to get it into date format.https://community.anaplan.com/t5/Anaplan-Platform/Date-Format-Conversion/m-p/131438#M33698 Thanks,Manjunath
Hi @neg177
Anaplan has a function DATE that allows you to input year, day and month to convert numbers into a date. In your case, you'd first need to dissect your list item names into a year, day, and month and then use it as input in your DATE function.
See this example by @Misbah here. This is the best way to go about it
Hi @ankit_cheeni @neg177 yes, its better to use Find formula to tell the position count if the format is not consistent. Thanks,Manjunath
Does anyone have any documentation on the trade-offs of having 1 model for all components of planning (service revenue, product revenue, labour planning), vs multiple models 1 for each and a consolidation model to tie it all together?
I am still now to the calculation of Anaplan XL, i would like to get the proportion in terms of value between child vs parent (within the hierarchy) For instance, i want to get the % of each 08S( child) vs the parent value (BL TS), i would like IN general a formula that give the proportion of child vs parent dynamically,…
Just like the main question above, I wanted to try out the new feature on the board where you can you the insights panel to put additional cards. However, I wanted to synchronize scroll a card on the main board with the card on the insights panel but I can't find where it might be.
