find the sum total of measure values

[misstoffeepenny]

Hi all,
I have 5 KPIs created in measures that I want to get a total value for, I've google it all and the best option i can find is :
=[Accident KPI Score] + [Site Inspection KPI Score] + [Site Returns KPI Score] + [Operational RA KPI Score] + [NC Target Date Met KPI Score]

however this returns an error: MdxScript(Model) (6, 126) Calculation error in measure 'SiteSlicer [Total KPI Score]: Cannot convert value " of type text to type numeric/ date

I don't understand how I'm getting this error when all values are = blank,0,5,10,15,20

any help appreciated

 

[misstoffeepenny]

fix is to remove the blank value and have it =0 when not scored