Forum Discussion
Column not adding measures correctly
Hi, I have a table with many different columns that are calculated measures. In the following image, the calculation of all the measures (horizontally) should be $122.92 but instead it shows an i...
Hi,
[Total Direct Costs] + [Claimed OH Organizational] + [Claimed O/H Material Handling] + [Special Asset Acquisition Allocation] + [Claimed O/H In-House] + [NDF Recoveries] + [Adjustments AC]
All of the measures within the calculation above are filtered value measures. They take the sum of burdened costs filtered by a certain expenditure type. The filtered value measure is a quick measure and doesn't account for blanks. How do you suggest I do that?
I need the Direct Costs Plus O/H calclulation to take the sum of each measure. So that means taking the sum of each of the measures below... which means it should be a total of $122.92 since all the other measures = blank or 0.