I have a list with employee names all in upper case. E.g. DANIEL SMITH
How can I convert these names in Anaplan to Daniel Smith (upper case on the first letter then lower case for the remaining)
Hi @RebeccaL - you'd need to use a combination of Left, Right, etc to get the desired result. There is this very old idea about having Proper() as a function within the platform.
Thank you, I think the function of Proper would be really helpful in Anaplan. Calculations can be used to get around this when it is a simple case of first and last name. I have some employee names where they have 2 middles name so it gets a bit complicated.
Hey , you can use lower(name(item)) to convert it to lower case
@Kanishq17 I guess he needs it to be in initial case, where you capitalize the first letter of every word. At present I don't think so we have any functions like that, we have UPPER, LOWER, LEFT, RIGHT functions to do the transformations.
Daniel Smith - upper case on the first letter then lower case for the remaining we don't have any function for such conversion in Anaplan currently.
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.β¦
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplanβ¦
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7β¦
