Finding Average using Formula

Crankzaton
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

Tagged:

Answers

  • Anilkumarch
    Anilkumarch

    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. 

     

  • Crankzaton
    Crankzaton
     

    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

  • Anilkumarch
    Anilkumarch

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

  • Crankzaton
    Crankzaton

     

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

     

    image.png

Categories