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
Multi-Cell Selection for Calculation Summary When selecting two or more cells in Anaplan, a calculation menu appears in the bottom-right corner displaying useful statistics such as Count, Min, Max, Average, and Sum. This is a helpful functionality for quickly analyzing selected values. However, the current functionality is…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
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.…
