Print only the value with min(date)

[#1]

Hello Guys,

I'm having serious trouble to write this one.

I wan't to print only the value that has the min date. Like an initial value.

I've tried this: =Sum({$<Date={"=$(=min(Date))"}>} Value).

How can i do it? =(

[alexandros17]

try

Sum( FirstSortedValue(Value, Date) )

[#3]

Hi Alessandro,

This return: "Error: ERror in expression: Nested aggregation not allowed"

[MK_QSL · Accepted solution]

SUM({<Date = {'$(=Min(Date))'}>}Value)

[ger_alegria]

Hello,

First, you can save in a variable the value of the min date:

vMinDate = min(Date) //Here you can choice if you want the min date of all data or the min date of the selection.

After that you can use the variable in expresion:

sum({<Date = {'$(=vMinDate)'}>}Value).

Let me Know if this help you.

[alexandros17]

You're right, try with:

FirstSortedValue(Value, Date)

[#7]

Thank's Guys!

Almost all of your answers has worked.