Make an expression to only includ 2016 data

[#1]

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

[avinashelite]

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)

[Anonymous]

=Count(DISTINCT{$<InnbetalingsStatus={'Har innbetalt'},Year_field={"='$(FadderskapOpprettetÅr )' "}>}AKTORID_FS_LOPENR) /Count(DISTINCT {<Year_field={"='$(FadderskapOpprettetÅr )' "}>}AKTORID_FS_LOPENR)