Expression

[#1]

hi,

I am using pivot table. in image column if count of green arrow is greater than 2 is shoul show green in status and if count of red is greater than 2 it should show red. how to apply expression in status column.

[CELAMBARASAN]

What expression your using to show the arrows? because it depends on that. We can control it using expression again it depends.

[#3]

Hi Celambarasan,

I am using image from expression window for green arrow but we can use green from trend column also.

Regards,

Piyush

[CELAMBARASAN]

I meant is there any logic is there to apply green or red or yellow.

Have you applied logic something like If(Value>50, Green, if(Value > 25, Yellow, Red ))?

[#5]

Hi,

I am using set analysis for that like =if(count({<Trend='Green>}Dt)>=2,'Green') but it is not working.

[saumyashah90]

Hi Piyush,

What you can do is. Count of image
i.e after you are done with images take an another expression counting that image and show RAG based on it

[CELAMBARASAN]

Try this.

If(Count(Total<Week123> {<Trend='Green>} Dt) >=2, 'Green')

[#8]

Hi Celam,

It is showing error at the second brases of set analysis when using{<Trend='Green' >}Dt).

Regards,

Piyush

[CELAMBARASAN]

Typo error If(Count(Total<Week123> {<Trend={'Green'}>} Dt) >=2, 'Green')

[#10]

Hi,

I am aware of that error but it is showing error in set expression.

Regards,

Piyush