Actual Vs sales target highlet and date

[#1]

HI

I have a chart which is having sales and target

target=100

when my sales meet target i can highlet using if(sales=target)

But my sales are 99,102,103,108 or 89,109,156.Here i don't have exact 100 so how can i achieve this?

can i use i st value of >100 list  how to achieve this?

If possible how i can get that date?

Regards

Thiru

[sorrakis01]

Hi,

Look this:

Regards

[Anil_Babu_Samineni]

In that, What are you Expecting?

[#4]

Hi Jordi,

i want to highlet only first value after 100 if it bigger than 102 then less value for 99

like

sales 100 to 102 (first value )

if not

lesser value like 99 or 98

if nor

100 to 120 also ok

Thiru

[#5]

Hi Anil

I am not getting out of this?

Thiru

[Anil_Babu_Samineni]

Can you please post your Small Application which demonstrates the issue? Please try to post paper work on Wall which you expected?

[Anil_Babu_Samineni]

I taken Jordi Example, Might be you are expecting similar this

[#8]

I want to highlet only target =actual

i.e 100=100

scnario2

if 100 is not there we need to highlet near to 100 i.e 102

Regards

Thiru

[Anil_Babu_Samineni]

Can you please share which expression you tried?

[sorrakis01]

Hi,

I'm confused but i Think you need a Rank Function.

Example on Target 100

A: Sales 120 --> 20

B: Sales 101 --> 1

C: Sales 100 --> 0

😧 Sales: 95 --> -5 If you use Fabs then 5

Rank Function sort by lowest. And after this you write if Rank(............) = 1 then green colour

Regards