Color expression for multiple colors is not working in Word cloud extension.

[Prabhu]

Hi All,

I am using the  below expression in Word cloud extension. It is picking only the first color. It is not working for remaining two colors.

=if(num(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT),'##.00%') <'70%', RGB(232,9,9),


if(num(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT),'##.00%') >='70%' and


num(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT),'##.00%') <='89%', RGB(250,166,53),


if(num(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT),'##.00%') >='90%', RGB(84,130,53))))

Please help me.

[Anil_Babu_Samineni]

that's what i initiate earlier, there could be some Round() issue to match each.