Hi,
I need to sum the elements of one column based on an element "text" of another column.
This text element isn't in a list so I can't use the function "Select".
What formula can I use ?
Thanks !
Best regards
That part of the extracted transactional code should relate to a known entity, so you can make a list for all the values of that entity. Call the list "Seg 2" for example. You will then need another line item to do a FINDITEM to "Seg 2" using that extracted text; this line item can then be used to SUM with.
Hi Mark,
Thanks for your answer.
I created a list and a new line item with the function FINDITEM.
I made a new module without "applies to" and with Year time scale.
I wrote this formula :
And I have this error message :
Can you help me again ?
Thanks
Hi @OrfeaLEFEVRE
You need to add "Seg 2" as a dimension in your new module, then this formula will work. Later you can use Select formula to extract that aggregated cell in another module.
Thanks!
-Shubham
I want to disable the [create page] button for the end user from the dashboard. The end user can create a page or worksheet to link to the module to edit the data. can anyone please give some suggestion? Thx…
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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…
