Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
that's what i initiate earlier, there could be some Round() issue to match each.