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