Converting negative values into a positive one

[#1]

Can someone please help me combine the 2 expressions below into 1?

Expression 1) =FABS(SUM([Data]))/100

Expression 2) Aggr(Sum (Data), [Test Description])

Thanks

[MayilVahanan · Accepted solution]

Hi

Try like something,

Aggr(Sum (Fabs(Data))/100, [Test Description])

or

Aggr(Sum (Fabs(Data)), [Test Description])/100

[CELAMBARASAN]

As per your expression it will be like

Fabs(Sum(Aggr(Sum(Data),[TestDescription])))/100

or

Fabs(Aggr(Sum(Data),[TestDescription]))/100

[#4]

thank you!