sum poitive numbers

[vvvvvvizard]

Imagine a table with the  sum of the expression below for each dimension of seglevel1  , sum all those numbers in the table that are positive for that value of seglevel1 , thats the total number i need please

Sum({< [Segment IS5_Description] ={'Headline Earnings'} >} ActZarYtd)

[vvvvvvizard · Accepted solution]

=Sum(Aggr(

IF(Sum({<[Segment IS5_Description] ={'Headline Earnings'}>} ActZarYtd)<0,
Sum({<[Segment IS5_Description] ={'Headline Earnings'}>} ActZarYtd),0)

,Segm_L1_Desc))