4 Replies Latest reply: Aug 30, 2018 7:13 AM by Andreas Jensen

# Combing IF-statement with Aggr()

Hi,

I'm using the code below to identify the top five performers and now I want get the average of those top five performers.

If(Rank(TOTAL SUM({\$<

[CompanyName]=,

[XBRL Reporting year]={\$(vXBRLThisYear)},

industry={\$(vChosenIndustry)}>}

[Årets resultat]))<=5,

SUM({\$<

[CompanyName]=,

[XBRL Reporting year]={\$(vXBRLThisYear)},

industry={\$(vChosenIndustry)}>}

[GrossResult]))

I have tried an aggr() function, but have not managed to succeed.

Does anyone have idea how to get the average value of top 5?

• ###### Re: Combing IF-statement with Aggr()

This isn't working?

Avg({\$<[CompanyName], [XBRL Reporting year] = {\$(vXBRLThisYear)}, industry={\$(vChosenIndustry)}>} Aggr(

If(Rank(TOTAL SUM({\$<[CompanyName], [XBRL Reporting year] = {\$(vXBRLThisYear)}, industry = {\$(vChosenIndustry)}>} [Årets resultat])) <= 5, Sum({\$<[CompanyName], [XBRL Reporting year] = {\$(vXBRLThisYear)}, industry = {\$(vChosenIndustry)}>} [GrossResult]))

, Performer))

• ###### Re: Combing IF-statement with Aggr()

Unfortunately not. No value is shown. But I don't understand where 'Performer' comes from?

• ###### Re: Combing IF-statement with Aggr()

It came from your description of the problem

I guess Performer is not a field name, but is rather called something else... replace Performer with the field which shows performers

• ###### Re: Combing IF-statement with Aggr()

It worked!! Thank you very much and have a nice day :-)