Calculation with Set Analys

[#1]

Hello,

Sum({$<[ProdH_L1]={11},[ProdH_L7Txt]={"Colorm IQ Sun"}>} [DebetFakturaKvantitet]) gives the row 'Colorm Sun'

Sum({$<[SurchGrupp]={"unicolor"}>} [DebetFakturaKvantitet]) gives the row 'Färg' .

[Colorm Sun]/[Färg] , this calculation works but I would like to have it as this

{$<[KundGrupp]-={13}>}[Colorm Sun]/[Färg], but this doesn´t work. so I have to use this

Sum({$<[ProdH_L1]={11},[ProdH_L7Txt]={"Colorm IQ Sun"},[KundGrupp]-={13}>} [DebetFakturaKvantitet])/ Sum({$<[SurchGrupp]={"unicolor"},[KundGrupp]-={13}>} [DebetFakturaKvantitet])

Is it possible to use this calculation, {$<[KundGrupp]-={13}>}[Colorm Sun]/[Färg], if yes,

what have I done wrong?

kindly

Håkan

[stigchel · Accepted solution]

No it is not possible, you can only use set expressions in an aggregation function.

[#3]

Thanks for the information.

Håkan