Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, Guys.
I want the Expression below to only include pledge donors that are recruited in 2016.
=Count(DISTINCT{$<InnbetalingsStatus={'Har innbetalt'}>}AKTORID_FS_LOPENR) / Count(DISTINCT AKTORID_FS_LOPENR)
The variabel is FadderskapOpprettetÅr and the year is as mentioned 2016
Best regards, Christian
You could add one more condition in the set analysis rite?
=Count(DISTINCT{$<InnbetalingsStatus={'Har innbetalt'},Year_field={"='$(FadderskapOpprettetÅr )' "}>}AKTORID_FS_LOPENR) / Count(DISTINCT {<Year_field={"='$(FadderskapOpprettetÅr )' "}>}AKTORID_FS_LOPENR)
=Count(DISTINCT{$<InnbetalingsStatus={'Har innbetalt'},Year_field={"='$(FadderskapOpprettetÅr )' "}>}AKTORID_FS_LOPENR) /Count(DISTINCT {<Year_field={"='$(FadderskapOpprettetÅr )' "}>}AKTORID_FS_LOPENR)