Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I Have writtten the set analysis below, and it works fine. As you can see i have used "1" as the set identifier. I choose 1 as identifier because the users might have done several choices and I want to ignore them. But now I do not want to ignore the choice the user has done for "Grlsoker_Klasordn_Grlhode_GRLID", only all the other choices made by the user.
In other words:
I want to ignore all the choices made by the user except "Grlsoker_Klasordn_Grlhode_GRLID". How can i do that?
Set analysis:
=count(DISTINCT{1<
Grlsoker_Klasordn_Grlhode_GRLID = {'20180302Søker'},
Grlsoker_SKOLENR={">15000 <16000"},
Grlsoker_ONSKENR={1},
Grlsoker_SOKSTAT={'B', 'C', 'D', 'G', 'U'},
Grlsoker_RETT={'U'}
>} Grlsoker_FNR)
Regards
Torbjørn
May be this?
=count(DISTINCT{1<
Grlsoker_Klasordn_Grlhode_GRLID = P(Grlsoker_Klasordn_Grlhode_GRLID),
Grlsoker_SKOLENR={">15000 <16000"},
Grlsoker_ONSKENR={1},
Grlsoker_SOKSTAT={'B', 'C', 'D', 'G', 'U'},
Grlsoker_RETT={'U'}
>} Grlsoker_FNR)
=count(DISTINCT{1<
Grlsoker_Klasordn_Grlhode_GRLID = ,
Grlsoker_SKOLENR={">15000 <16000"},
Grlsoker_ONSKENR={1},
Grlsoker_SOKSTAT={'B', 'C', 'D', 'G', 'U'},
Grlsoker_RETT={'U'}
>} Grlsoker_FNR)
May be this?
=count(DISTINCT{1<
Grlsoker_Klasordn_Grlhode_GRLID = P(Grlsoker_Klasordn_Grlhode_GRLID),
Grlsoker_SKOLENR={">15000 <16000"},
Grlsoker_ONSKENR={1},
Grlsoker_SOKSTAT={'B', 'C', 'D', 'G', 'U'},
Grlsoker_RETT={'U'}
>} Grlsoker_FNR)
Hi Mwoolf,
thanks for swift reply, but it does not seem to work. Should it be any tokens, etc.?
Regards,
Torbjørn
Hi
thanks for your reply Vishaggi! Perfect!
Regards,
Torbjørn
If you want only direct selection to impact you can try this
=count(DISTINCT{1< Grlsoker_Klasordn_Grlhode_GRLID = $::Grlsoker_Klasordn_Grlhode_GRLID, Grlsoker_SKOLENR={">15000 <16000"}, Grlsoker_ONSKENR={1}, Grlsoker_SOKSTAT={'B', 'C', 'D', 'G', 'U'}, Grlsoker_RETT={'U'} >} Grlsoker_FNR)