I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it.
Is there an XL3 formula to return this value?
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Hi, I need help. I have a hierarchical Line Item Subset (LISS) in my model. Sometimes, I want to select a parent item directly in a filter, so that only the parent is displayed β not its children. The challenge is that on a LISS, I cannot tick a parent in a module (since Anaplan only allows selecting child items). I triedβ¦
The default date format in Anaplan is mm/dd/yyyy. How do i change the date format as dd/mm/yyyy. For example, In my source file the date is 7/12/2020 which is dd/mm/yyyy. I would like to maintain this format in anaplan. If i reference the date 7/12/2020 in my period formula the output should be Dec-20 and not Jul-20.