Powerpivot date problem

[Paul Wakefield]

I am trying to use the Cubevalue function but am having a problem when using a reference to a date in a cell.

e.g.

=CUBEVALUE("powerpivot data","[Sum of "&B$9&"]","[Current].["&'Scheme Tables'!E21&"]","[SchemeName].["&$A10&"]","[FormatDate].[02/11/2009]")

works fine but I can not get

=CUBEVALUE("powerpivot data","[Sum of "&B$9&"]","[Current].["&'Scheme Tables'!E21&"]","[SchemeName].["&$A10&"]","[FormatDate].["&C4&"]"),

where C4 holds the date, to work.

I have tried all sorts of date/numeric formats both in the cell and in the Powerpivot table with no success.

Any help would be gratefully received.

 

[BrucePorter]

Try

=CUBEVALUE("powerpivot data","[Sum of "&B$9&"]","[Current].["&'Scheme Tables'!E21&"]","[SchemeName].["&$A10&"]","[FormatDate].["&TEXT(C4,"dd/mm/yy")&"]")

Hope this helps.

 

[Paul Wakefield]

Bruce,

My apologies for the delayed reply. That worked a treat.

Thank you so much.

Paul