FirstSortedValue and Aggr?

[#1]

I have the following data:

In the straight table (top) the formula for "Assigned" is aggr(FirstSortedValue(AR.MLATS,AR.FullTime),AR.Company) but this is

returning "Null". There are only two values for MLATS for this account, as shown in the second table box.

Why is FSV not working here? Does it not work inside AGGR? (I tried it without the AGGR function, and got the message "Error: can't calculate column"; adding AGGR turned it to Null. ) Also, the formula for "Incoming Lead" in the straight table is Aggr(AR.IncTS,AR.Company), and it works fine.

Any thoughts on how I might pick the first of the two MLATS values?

[swuehl]

Try to use

=FirstSortedValue(AR.MLATS, AR.FullTime)

as expression, not as calculated dimension.

[#3 · Accepted solution]

Thanks, but I ended up using =date(aggr(min(AR.MLATS),AR.Company),'MM/DD/YY hh:mm:ss') for the

first one, and max() for the second one. Works perfectly.