Hi ,

I want applying cell calculaltion and using condition for changing the
fore_color property
of the Cell. I want to apply FORMAT_STRING irrespective of the
condition. Is it possible to apply a specific format irrespective of
condition ?

Currently , it is applying FORMAT_STRING propertty when condition
evaluates to true.

Regards,

Faraz

Thanks in Advance

----------------------------------------------------------------------------------------------------------------------
-- Q U E R Y F O R F O R M A T
----------------------------------------------------------------------------------------------------------------------
With Cell Calculation MY_CELL For
'( { [Measures].[Sales Count]} )' As
'CalculationPassValue(Measures.CurrentMember, -1 ,Relative )',
CONDITION =' CalculationPassValue((ParallelPeriod ([Time].[Month],
1,[Time].CurrentMember),Measures.[Sales Count]), -1, RELATIVE) * 0.95
< CalculationPassValue( [Measures].[Sales Count], -1,Relative ) ',
SOLVE_ORDER ='2000', FORE_COLOR ='11005',
CALCULATION_PASS_NUMBER ='2', CALCULATION_PASS_DEPTH ='1' ,
FORMAT_STRING='#,##0.00'
SELECT
{ CrossJoin({[Customers].[Country].[USA].CHILDREN},
{Measures.[Sales Count]})} ON COLUMNS ,
{{[Time].[Month].MEMBERS}} ON ROWS
FROM [Sales] CELL PROPERTIES
[VALUE],[FORMATTED_VALUE],[CELL_ORDINAL],[FORE_COLOR

------------------------------------------------------------------------------------------------------------------------

One option would be to incorporate the condition within the color expression:

'( { [Measures].[Sales Count]} )' As
'CalculationPassValue(Measures.CurrentMember, -1 ,Relative )',
FORE_COLOR =' iif(CalculationPassValue((ParallelPeriod ([Time].[Month],
1,[Time].CurrentMember),Measures.[Sales Count]), -1, RELATIVE) * 0.95
< CalculationPassValue( [Measures].[Sales Count], -1,Relative ),
11005, 0) ',
SOLVE_ORDER ='2000',
CALCULATION_PASS_NUMBER ='2', CALCULATION_PASS_DEPTH ='1' ,
FORMAT_STRING='#,##0.00'
SELECT
{ CrossJoin({[Customers].[Country].[USA].CHILDREN},
{Measures.[Sales Count]})} ON COLUMNS ,
{{[Time].[Month].MEMBERS}} ON ROWS
FROM [Sales] CELL PROPERTIES
[VALUE],[FORMATTED_VALUE],[CELL_ORDINAL],
[FORE_COLOR]

"Faraz" wrote: