Expression within expression in stead of a hard value

[shahamel]

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

[shahamel]

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