Conditional Expression

[lylererger]

Hi.
I'm searching for the way to show dimention value in text box.
I've got currency rates by banks in single table. And my problem is to show the bank with the best rate.
My expression looks like: max(aggr(sum(Rate),Bank)).

Thnx.

[ThornOfCrowns]

And what does that expression bring back?

[lylererger]

Best Banks Rate I think.

[anbu1984]

Can you post your data, Current result and Expected result?

[fkeuroglian]

Please put an example to understando and can help you

[lylererger]

I hope it helps.

[bertdijks · Accepted solution]

HI See Attached example,

I loaded a few Lines

LOAD * INLINE [
    Bank, Rate
    A, '0,7'
    B, '0,8'
    C, '0,5'
    D, '1,2'
    E, '1,1'
];

I want Bank D to show as the bank with the highest rate

First I determen the row containing the highest rate:

fieldindex( 'Rate', max(Rate) ))--> row number 4

Finnaly I retrieve the value of Bank in the 4th row:

Fieldvalue('Bank',fieldindex( 'Rate', max(Rate) ))

Kind regards,

Bert