HOW TO RANK DATE AND VALUE

[antoniodneto]

Hi guys!!

I got this table:

There is showing the TOP and LAST DATES following the expression below:

='+' & max(aggr(if(rank(sum(RISCO_C_11_14 + RISCO_D_15_30)/Sum(RISCO_EM_DIA_LAG1),4)=1,DATA_BASE),DATA_BASE))

& chr(10) &

'-' & min(aggr(if(rank(-(sum(RISCO_C_11_14 + RISCO_D_15_30)/Sum(RISCO_EM_DIA_LAG1)),4)=1,DATA_BASE),DATA_BASE))

And now I'm trying to show also que value of the SUM with the DATE, how can I put the expression with?

Tks!!!

[zebhashmi]

look like you can keep adding sum for value and max fro date almost similar you did.

[antoniodneto]

Yeah I'm think so! But I can't set into the sentence, I doing something wrong

[zebhashmi]

Do you need rank inside the if?

[antoniodneto]

I need to show the top and last date and value for example, not just the date.

+201703 - 3.8% - 201701 - 5,6%

Tks!