Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
= 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).
May be this:
Avg({<InnbetalingsStatus={'Har innbetalt'}>} [#ReskontroInnbetaltBeløp]) * -1
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
Or maybe
=Avg({<AKTORID_FS_LOPENR = p({$<InnbetalingsStatus={'Har innbetalt'}>}) >} [#ReskontroInnbetaltBeløp])*-1