I can't get my sum to work

[#1]

Morning everyone,

Can someone help me with the following sum please;

I'm trying to sum all AUMValue where the AUM_StartAt is the minimum within that field, I've got the following but it doesn't work

=sum(if(AUM_StartAt=Min(AUM_StartAt),AUMValue))

Can anyone help please?

[alexandros17]

Try this:

if(AUM_StartAt=Min(AUM_StartAt, Sum(AUMValue))

let me know

[nilo_pontes]

Good morning Samuel,

Try: sum({< AUM_StartAt = {'$(=Min(AUM_StartAt)'} >} AUMValue)

Best Regards,

Nilo

[tresesco]

You can't use one aggregation function in another unless you use Aggr(). For your case take a variable and try like:

vMin=Min(AUM_StartAt)

Then expression like: =sum(if(AUM_StartAt=$(vMin),AUMValue))

[#5]

Hi Samuel

This will only give you the value of the min AUM_StartAt...

Can you give us some sample data to work with?

brgds,

Anthony

[#6]

Ok, this is what I've got (that works) I just need to try and avoid set analysis as I need the users to be able to interact with the chart and that currently isn't happening;

=sum({AUM_StartAt={'$(=date(Min(AUM_StartAt)))'}>}AUMValue)

I need to replicate this without using set analysis

[nilo_pontes]

Samuel,

Then try tresesco's solution.

Regards.

[#8]

I have tried that, unfortunately it returns a blank value. It's really rather odd.

[sorrakis01]

Hi,

try tresesco's solution.

I think is the correct answer.

Cy

[maxgro · Accepted solution]

sum(if(AUM_StartAt=max(TOTAL AUM_StartAt), AUMValue))