Hi @Madelyn_SAS ,   though our developer still haven't change the data type of the numeric data items, I found another way to build the desired variable. My way is to separate the item in 2 parts. So I build one calculated item A ('quantity'n * 'unit_price'n) and another calculated item B (Distinct [_ByGroup_] ('oder: ID'n)). Then I put them together in calculated item C: Sum [_ByGroup_] (A) / B. And it works!! Do you have any idea, why this new item works? I still don't get it at all. 😛   Best,   Oliver ... View more