Hi Everyone,
I have line items which is the concatenated string
ex - 123,435,234,678,567,987
I would like to find no of strings present ie 6
Could you please help me with this.
Thanks
Tejaswini
Hi @tejaswini ,
As Anaplan doesn't have a native text counting formula you can use this workaround to find the number of separators in the concatenation, thus giving the number of items concatenated:
Number of seperators = LEN(Text) - LEN(SUBSTITUTE(Text, ",", "")) = 5
This will give you the number of separators in your case "," in the string, then just do +1 for the number of original items concatenated.
Andris
substitute really is quite a useful function!
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
