How to create a SUM formula from a list but the format of the line item on the list is text
and how to automate upload data from SQL server into Anaplan
thank you
@josephine_surja
@sulistyapratiwi1020
SUM only works on the numbers. There is a function called TEXTLIST which should do the job for you. However TEXTLIST impacts the performance of the engine, so use it cautiously.
You can use Anaplan Connect or other options. Similar thread here
Connect to SQL server - Anaplan Community
Misbah
Aggregation functions like SUM operate using LIST formatted line items on TEXT. This is because text strings are not meaningful and therefore are not able to direct the function as to what items to include in the aggregation.
Also, the target of the SUM must be dimensioned by the LIST being used in the mapping.
To use the TEXT data as a mapping in your model you need to convert the contents of the line item into a list.
Use ISFIRSTOCCURRENCE and a boolean line item to filter your module to only show unique entries. Create a saved view only showing the TEXT data and use the boolean to filter out all duplicates.
Next, use this view to update a list using an import action - Import into a list.
Create your mapping that will inform the SUM function using this updated list - SUM.
Your mapping table should contain the same dimensions as the source and contain a list formatted line item containing the relevant mapping. Here, you would format the line item using your updated list.
The target should be dimensioned by the list. The SUM function will aggregate the data as per the mapping table.
As for the automating the upload refer to @Misbah link.
Good luck,
Chris
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
