i want to extract the property of the Measure or Metric and then apply
on the Cell Calculation to show the same format as the measure or
metric.

this is the query to have an idea what i want to do

With Cell Calculation MY_CELL For
'( { [Measures].[Sales Count]} )' As
'CalculationPassValue(Measures.CurrentMember, -1 ,Relative )',
CONDITION =' Some Condition will be here'
, SOLVE_ORDER ='2000',
FORE_COLOR ='11005',
CALCULATION_PASS_NUMBER ='2', CALCULATION_PASS_DEPTH ='1' ,
----------------------------------------------------------------------------------------------------------
-- Here i want to set the format_string Property same as Sales count
Measure
----------------------------------------------------------------------------------------------------------
FORMAT_STRING = '#0.00'

SELECT
{ CrossJoin({[Customers].[Country].[USA].CHILDREN},{Measures.[Sales
Count]})} ON COLUMNS ,
{{[Time].[Month Of Year].MEMBERS}} ON ROWS
FROM [Sales] CELL PROPERTIES
[VALUE],[FORMATTED_VALUE],[CELL_ORDINAL],[FORE_COLOR]


Thanks in Advance,

Faraz