Finding Average using Formula

Crankzaton
edited February 2023 in Modeling

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

Answers

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

    image.png

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

     

    image.png