CUBEVALUE formula that i need to change the reference to a cell

[shophoney]

Hi I would like to know how to remove a specific reference to a location in a CUBEVALUE formula and have it reference a cell for the location #.

Below is my formula and it references location 9000 and I would like it to refer to whatever is in cell C6


=CUBEVALUE("ThisWorkbookDataModel","[Measures].[1YR AGO OH COST]","[dCLASS].[CLASS].[All]","[MachineCode]",Slicer_YEAR1,Slicer_MONTH1,Slicer_TRANS_DATE,Slicer_CLASS7,Slicer_NAME7)-CUBEVALUE("ThisWorkbookDataModel","[Measures].[1YR AGO COST TRANSFERED]","[dCLASS].[CLASS].[All]","[TRANSFERS].[loc# to].&[9000]",Slicer_YEAR1,Slicer_MONTH1,Slicer_TRANS_DATE,Slicer_CLASS7,Slicer_NAME7)+CUBEVALUE("ThisWorkbookDataModel","[Measures].[1YR AGO COST TRANSFERED]","[dCLASS].[CLASS].[All]","[TRANSFERS].[loc# created].&[9000]",Slicer_YEAR1,Slicer_MONTH1,Slicer_TRANS_DATE,Slicer_CLASS7,Slicer_NAME7)

Thanks

 

[Macropod]

You might try replacing the instances of:
[9000]
with:
[" & C6 & "]

 

[shophoney]

Thanks that did the trick