Min/Max aggregated function

[#1]

Hi all,

I'm trying to find max, min values for netted amounts throughout the day.

For every hour I'm calculating the net value for incoming and outgoing payments, leaving a negative or positive value.

Now I wish to rank these netted flows, for instance the largest positive and negative hourly flow for the selected date.

I tried the below, the syntax seems to be OK, but I'm only getting null values in return.

any ideas?

MAX  (AGGR  (SUM  (  {<Receiver = {'US'}>} [Amount] )- sum(  {<Receiver -= {'US'}>} [Amount]  ), Time  )  )

Thanks in advance,

Olle

[PrashantSangle]

Hi,

Try something like this,

MAX  (AGGR  (SUM  ({<Receiver = {'US'}>} [Amount]),Time)) - Max(AGGR  (sum(  {<Receiver -= {'US'}>} [Amount]),Time))

Regards,

[MK_QSL]

Max(Aggr(Max({<Receiver = {US'}>}Amount)-Max({<Receiver -= {US'}>}Amount),Time))

[#4]

Hi Max,

tried it and it's giving me the very same results as the below "core" calculation.

sum( {<Receiver = {'US'}>} [Amount] )- sum( {<Receiver -= {'US'}>} [Amount] ))

@MAnish,

receiving null values with your code.

//O

[PrashantSangle]

Hi,

Can you post sample application.

Regards,

[#6]

Pls see attached Sample File, I've replaced counterpart names to "THEM" so no need for the -=US.

//O

[jonathandienst · Accepted solution]

Hi

Are you using this in a chart/table with the date as a dimension? If so, you need to include this dimension in your Aggr() function. Like this (assuming the date is a field called [Date]):

Max(Aggr(Sum({<Receiver = {'US'}>} [Amount]) - Sum({<Receiver -= {'US'}>} [Amount]), [Time], [Date]))

HTH

Jonathan

[#8]

Thanks Jonathan!