I'm having trouble with level 8 Rep02 I'm getting the following error: Data type mismatch: format other than LIST or DATE being referenced as a relation
I hope you can see my screen print with the other modules referenced
I found my error, in my sys06 module, i didn't have the size formatted as list.
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.