Hi,
i was trying to calculate Modal price(most frequent) for a measure
using the below formula which is syntactically correct

EXCEL!Mode (
SetToArray (
Descendants (
[Time].[Monthly].CurrentMember,
[Time].[Monthly].[Date]
),
[Measures].[Target Price]
)
)


but it is giving error as "Unable to display cell properties The
operation has failed because of an error in the COM component Type
Mismatch.An error occured during attempt to get cell value"

Do i need to register any excel library or anything which i am not
able to understand

Whether my approach is correct for calculating Statistical modal price
for a measure

Urgent help is required

Regards
Prasanna