Hi!
I am getting zeros in my data when I am using the LOOKUP function. What are the possible reasons for this? I am sure that I am using the function correct. The function works but the data only shows zeros.
Hi @Leonolgun
The problem may be that a summation element is chosen as the argument. This is a feature of the function. The solution is in my article: https://community.anaplan.com/t5/How-To/How-to-use-LOOKUP-with-summary-elements/ta-p/137853
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
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.…
