Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Type | Percent | Red | Amber | Green |
Cost | 4.33% | Above 5% | 0-5% | Under 0% |
Quality | 9.33% | Below 3% | 3-6% | Above 6% |
Availability | 6.33% | Above 4% | 2-4% | Less than 2% |
Type is my 3 pies in the pie chart and I have to set the RAG for each pie.Is this possible ?
Thank you,
Perhaps this?
If(Type = 'Cost' and Percent > 0.5, Red(), If(Type = 'Cost' and Percent >= 0.0 and Percent <= 0.5, LightGray(), If(Type = 'Quality' and Percent < 0.0, Green(), If(Type = 'Quality' and Percent < 0.3, Red(), If(Type = 'Quality' and Percent >= 0.3 and Percent <= 0.6, LightGray(), If(Type = 'Availability' and Percent > 0.6, Green(), If(Type = 'Availability' and Percent > 0.4, Red(), If(Type = 'Cost' and Percent >= 0.2 and Percent <= 0.4, LightGray(), If(Type = 'Availability' and Percent < 0.2, Green())))))))))
Perhaps this?
If(Type = 'Cost' and Percent > 0.5, Red(), If(Type = 'Cost' and Percent >= 0.0 and Percent <= 0.5, LightGray(), If(Type = 'Quality' and Percent < 0.0, Green(), If(Type = 'Quality' and Percent < 0.3, Red(), If(Type = 'Quality' and Percent >= 0.3 and Percent <= 0.6, LightGray(), If(Type = 'Availability' and Percent > 0.6, Green(), If(Type = 'Availability' and Percent > 0.4, Red(), If(Type = 'Cost' and Percent >= 0.2 and Percent <= 0.4, LightGray(), If(Type = 'Availability' and Percent < 0.2, Green())))))))))
Thank you.