Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
And what does that expression bring back?
Best Banks Rate I think.
Can you post your data, Current result and Expected result?
Please put an example to understando and can help you
I hope it helps.
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