After struggling with this for two days I'm turning it over to the experts.
I have two relatively simple tables in PowerPivot. Table 1 has labor costs by project and table 2 has the fringe rates for each project. I would like to add a calculated column to table 1 that shows the fringe cost, which is calculated by multiplying the labor cost (table 1) by the fringe rate for that project (table 2). I thought it would be simple but I keep getting a blank column. I am certain that the text in the relationship column matches exactly (it is an alpha-numberic id code). The columns with the relationship are defined and formatted as text. The columns being used in the calculation as well as the calculation column itself are defined as decimal number. I have tried everything including starting a new PowerPivot from scratch. Every time I am getting the same result - a blank column. The formula I'm using is:
RELATED('Project Fringe-Indirect Rates'[Fringe Rate])*'Job Cost Data'[MeasuresTotal Cost]
I couldn't figure out how to upload an image of the tables so I'm hoping you can go off of what I've posted. I believe the problem is with the relationship because even when I simply use the RELATED function to pull in data from any column in table 2, I'm getting blanks. I just can't figure out what the problem is. What are the problems/mistakes that could cause this to happen?
Any and all suggestions are very much appreciated.
I have two relatively simple tables in PowerPivot. Table 1 has labor costs by project and table 2 has the fringe rates for each project. I would like to add a calculated column to table 1 that shows the fringe cost, which is calculated by multiplying the labor cost (table 1) by the fringe rate for that project (table 2). I thought it would be simple but I keep getting a blank column. I am certain that the text in the relationship column matches exactly (it is an alpha-numberic id code). The columns with the relationship are defined and formatted as text. The columns being used in the calculation as well as the calculation column itself are defined as decimal number. I have tried everything including starting a new PowerPivot from scratch. Every time I am getting the same result - a blank column. The formula I'm using is:
RELATED('Project Fringe-Indirect Rates'[Fringe Rate])*'Job Cost Data'[MeasuresTotal Cost]
I couldn't figure out how to upload an image of the tables so I'm hoping you can go off of what I've posted. I believe the problem is with the relationship because even when I simply use the RELATED function to pull in data from any column in table 2, I'm getting blanks. I just can't figure out what the problem is. What are the problems/mistakes that could cause this to happen?
Any and all suggestions are very much appreciated.
