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