Help // Convert Expression to a Dimension

[nlucia]

Good afternoon, I'm needing help to convert an Expression into a dimension.

IF([% Advance Proyect]> 0.10,

IF(ALT(( ( [Hrs Estimate PM * % Advance Proyect]) - sum({<Tecno={'PMO'}>}hours)) / ([Hrs Estimate PM * % advance Proyect]),1) >= -0.10 ,'Green',

IF(ALT((([Hrs Estimate PM * % Advance Proyect]) - sum({<Tecno={'PMO'}>}hours)) / ([Hrs Estimate PM * % Advance Proyect]),1) < -0.10 AND
ALT((([Hrs Estimate PM * % Advance Proyect]) - sum({<Tecno={'PMO'}>}hours)) / ([Hrs Estimate PM * % Advance Proyect]),1) >= -0.25,  'Yellow',  'Red')),  'white') 

I need to count Proyects in diferrent colours (semaphore).

I have it like expression in a table and it work .

thank you so much

[Lisa_P]

If it works to color your table, the same expression should work for a calculated dimension. just change the labels from colors to descriptions of the classification.

IF([% Advance Proyect]> 0.10, 
     IF(ALT(( ( [Hrs Estimate PM * % Advance Proyect]) - sum({<Tecno={'PMO'}>}hours)) / ([Hrs Estimate PM * % advance Proyect]),1) >= -0.10 ,'>= - 10%',    .....

[nlucia]

Hi Lisa!I tried but it still didn't work. 😞 

[Lisa_P]

Can you show the screenshot of the expression editor please ?