Set analysis question

[#1]

= if(DISTINCT{$<InnbetalingsStatus={'Har innbetalt'}>}AKTORID_FS_LOPENR) Avg([#ReskontroInnbetaltBeløp])*-1

Hi,

Why does not this Expression work?

I want to see the average payment (#reskontroinnbetaltbeløp) amongst donors that has made at least one payment (har innbetalt).

[sunny_talwar]

May be this:

Avg({<InnbetalingsStatus={'Har innbetalt'}>} [#ReskontroInnbetaltBeløp]) * -1

[kaushiknsolanki]

Hi,

its because If statement do not allow set analysis.

Set analysis should be used with aggregation functions.

correct expression will be.

Avg({<InnbetalingsStatus={'Har innbetalt'}>}AKTORID_FS_LOPENR)

Regards,

Kaushik Solanki

[swuehl]

Or maybe

=Avg({<AKTORID_FS_LOPENR = p({$<InnbetalingsStatus={'Har innbetalt'}>}) >} [#ReskontroInnbetaltBeløp])*-1