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
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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.…
This item has been identified as an outstanding known issue. Issue Setting a current page filter or sort and then exporting this data to file, will apply the current page filter/sort to all pages of the data. Workaround Remove all filters/sorts, export the data, and apply the filters/sorts in Excel --- Internal Reference:…
