Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a EPS by company for about 10 company. I want to flag the top highest EPS company.
I use below expression :-
max(aggr($(vEPS),COMPETITOR_k))
I get blank . Can some one advise me where i go wrong ?
Paul
my QVF
You want to flag it? May be try this:
If(Rank($(vEPS)) < 2, 1, 0)
Hi Sunny
Thank you very much for your help.
I need the set point for flag dynamic , in case I select 2 stock , which EPS higher will be flag. Can you advise me how to do this ?
Paul Yeo
Director
www.tdstech.com<http://www.tdstech.com>
HP+6285883521036 Indo
Hi Sunny
I relook at your expression , I think your is correct , now what I need is I want the column with EPS higher ranking mark with yellow Color on the back ground Color. So I don't need the flag column.
Paul Yeo
Director
www.tdstech.com<http://www.tdstech.com>
HP+6285883521036 Indo
Hi Sunny
This is 100% what i am looking for. it work fine now.
Paul
Hahahaha I am glad it worked because I went to sleep after giving typing my response