If the KPI with that name exists in the cube, can you not retrieve it using something like this?
KPIValue("New Units Sold")
Like the working example I show in my last response? Using this syntax, you would be asking for "the value of the New Units Sold KPI ..."
Sorry if I'm missing something ...
Bill