Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear QV-Users
I have this expression
num
(
sum({<
TaakSchaalscore.tss_taa_score =
{"= TaakSchaalscore.tss_taa_score = 40"}
>}
TaakSchaalscore.tss_schaalscore)
,'#.##0')
It's result is 52
I would like to use this expression
num
(
sum({<
TaakSchaalscore.tss_taa_score =
{"= TaakSchaalscore.tss_taa_score = aggr(max(toetsResultaat.score),Inspectiesleutel)"}
>}
TaakSchaalscore.tss_schaalscore)
,'#.##0')
This expression gives also 52 as result, BUT you have to make sure you selected TaakSchaalscore.tss_taa_score = 40
aggr(max(toetsResultaat.score),Inspectiesleutel) <-- this expression gives 40 as result in this case.
as you can see i tried to use it within the expression above. It works, but i would like to make it work WITHOUT making a
selection in TaakSchaalscore.tss_taa_score
Help please
I would like to have a column which gives
the score for each inspectiesleutel
next to this column i like to have
the 'schaal' which corresponds with the score.
It is like this.
Each inspectiesleutel has one score (toetsresultaat.score)
Each taakschaalscore.tss_taa_score has one taakschaalscore.tss_schaalscore when combined with one
speciic
toetsondrdeel.dodToetsCode