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

[#2]

Hi Anil

Please try this

action date on chart based on max value

Regards

Thiru

[sorrakis01]

Hi,

Use this If(Rank(-Fabs(Sum(Sales)-100)) = 1,Green(),Blue())

Regards

[sorrakis01]

Hi,

Here is the exemple.

Chnage the values in the inline section.

Regards

[sorrakis01]

Hi,

Finally resolved this problem?

Regards

[#6]

Hi Jordi,

It's working but i need to concentrate some more scenarios,like as i said

some tomes it will not be exact matching.so it will give near values

this is working  If(Rank(-Fabs(sales-100)) = 1,1,0)

but i want to get this

if(fabs(if(Date>=$(V_Date),sales)-$(Max %))

= min(total aggr(fabs(if(Date>=$(V_Date),Sales)-$(Max %))

,Date)),$(Max %),0)

If you are good in fabs function

can you please modify the above.

for your reference please check

action date on chart based on max value

Regards

Thiru