Hi Team, I was trying to Import the wrong data(combination of text and numbers) to my numbered format line item "Data". However, Anaplan did not through any error for the same(mentioned in the below screenshots).
Just curious to know how Anaplan treats this kind of data and can someone please explain how this will work in behind? Regards, Venkatesh
Hi @Venki9902
As the line item in which you are importing is Numbered formated, so it will ignore the Text and only import the Number, where as if you change the line item format to the Text it will consider the value as text and import the full value ie: combination of alphanumeric.
Please refer to the ss below.
Hope this helps you..!
Hi @Venki9902 ,
Please go through the below link for a more detailed understanding.
Hi @Girish and @Relanto , Thank you for your details. But however, what I am trying to convey is instead of creating the extra line items to check if the data has a perfect number(not an alphanumeric character) Anaplan should through an error or something :). Regards, Venkatesh
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.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
Estimated Level of Effort: <4 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L1 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased response time to address risks Increased forecast accuracy You Might Also Like: * Tops-Down Allocations Historical Snapshotting One of…