Finding Average using Formula

Highlighted
New Contributor

Finding Average using Formula

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 meimage.png


 

image.png

 image.png

Kindly guide me.Thanks in advance

4 REPLIES 4
Highlighted
Certified Master Anaplanner

Re: Finding Average using Formula

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. 

 

Highlighted
New Contributor

Re: Finding Average using Formula

 

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.

image.png

Highlighted
Certified Master Anaplanner

Re: Finding Average using Formula

@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.

Highlighted
New Contributor

Re: Finding Average using Formula

 

Thanks a lot man.Finally it got done with your guidance! So happy and thanks for the suggesstions man 

 

image.png