I have the following measure that is used in a bar chart to show a monthly efficiency percentage:
//sum all running core resources Sum( {< [Resource Code]={'Running / Iterations'} , [Resource Category]={'Core'} >} Quantity_Adj ) / (( Count(Distinct Day([Previous Date Time])) * 24 //multiply by 24, hours per day in the mongh * Count( {<[Resource Category]={'Core'}>} Distinct Resource ) //for core resources only ) - Sum( {< [Resource Code]={ 'No Samples / Support Parts' , 'No Project' , 'Holiday' , 'Calibration Parts / Project' , 'No Power' , 'Development' , 'Maintenance Parts / Project' } //subtract all codes that are out of our control , [Resource Category]={'Core'} //for core resources only >} Quantity_Adj ))
I need to display the YTD average of this expression output, but it will not work because of this part of the expression:
(( Count(Distinct Day([Previous Date Time])) * 24 //multiply by 24, hours per day in the month * Count( {<[Resource Category]={'Core'}>} Distinct Resource ) //for core resources only )
