Couple of Trellis (LED) specific questions - Help please

[#1]

Hi,

I am struggling with the formatting of

a) Trellis chart titles in that they include both dimensions. Is there any way I can just include the 1st dimension in the title?

b) I want to change the colour of the LED to red where less that 4.2. I have tried using the 'Calculated' area of the LED colour using: =if(Sum(RecordCounterRATED*Value)/Sum(RecordCounterRATED)>=4.2,LightGreen(),LightRed())

This doesn't appear work for Trellis and either sets all results to red or all to green.

Any help would be appreciated,

[Marcio_Campestrini]

Hi Jim

Can you post a simple qvw to analyse?

[#3]

can you possibly post the application or qvw with the same issue?  where are you placing your calcualted color expression?

did you place it in the color tesxt or background of the expression

[Marcio_Campestrini]

Hi

Have you solved your problem? If you did, please choose the correct answer and help us to keep community focused.

[Anil_Babu_Samineni]

Better approach if you shared the file

=if((Sum(RecordCounterRATED*Value)/Sum(RecordCounterRATED))>=4.2,LightGreen(),LightRed())