I have a table with Grade,Region,Salary of employees and i neeed to find the average of salary by region in another module and i am getting an error. I am new to the platform.Kindly guide me
Kindly guide me.Thanks in advance
Hi @Crankzaton I think you are getting the error bcoz the region line item in Grade Test module is TEXT format. You can only do the AVERAGE only by list format.
Hey,Anilkumarch thanks man that worked like a bingo.But here i get a error for dimension mismatch and i am not sure how to have a dimension in the result module.Kindly help with this.
@Crankzaton your target line item or module should be demsioned by Region list as you are doing the average by Region.
What ever the list item you are using for Average the tagert module should have that dimension.
Thanks a lot man.Finally it got done with your guidance! So happy and thanks for the suggesstions man
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.…
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…