Total and Others value wrongly interpreted in straight table

[Anonymous]

Hi

I am using a straight table to show values. In the dimension limits, I have set the properties of the table to show only the first 20, and to also show the other values as "All Others" and to display the sum "Global" on the first row.  I am interpreting the values according to the target legend on top. In this case I am interpreting the Group M values to display the corresponding smiley color (red, orange and green).  For the values according to dimension, it is interpreting the color of the smiley correctly but not for the "Global" and "All Others" values.  In the first table for Global it should display a red smiley and for All others as well but it is showing a green one.  For determining the color of the smiley which is an image, I am using the following code in the expression to display the image:

=if([Group - M] <= (Sum({$<KPI_Group_Name={'Reb_Rate_30'}>}KPI_Group_Threshold_1)),'$(v_IMAGES)'&'\Smiley_Green.png',

if([Group - M]<=(Sum({$<KPI_Group_Name={'Reb_Rate_30'}>}KPI_Group_Threshold_2)),'$(v_IMAGES)'&'\Smiley_Orange.png','$(v_IMAGES)'&'\Smiley_Red.png'))

Kindly advise of how to fix this issue

Thanking you in anticipation

Regards

Hasnaa

[#2]

Can you post a sample app with small data?

[Anonymous]

Hi

Please find attached a sample app.  The color of the smiley for Total and Others is being wrongly interpreted. For the values, it is working fine.  I have used dimension limit to set the total and Others properties

Thank you

Hasnaa

[#4 · Accepted solution]

Hi Hasnaa,

Just try the following expression in your image colum:

=if(Value <= Num(Only({$<KPI={'test'}>}Threshold_1)),'Smiley_Green.png',

if(Value <=Num(Only({$<KPI={'test'}>}Threshold_2)),'Smiley_Orange.png','Smiley_Red.png'))

(Instead of calculating the sum of thresholds - therefore the error in the total, use only the value of the Threshold).

Regards,

Jaime

[Anonymous]

Thanks. It works

Hasnaa