Average with negative values

[17George]

Hello,
On the left side the scores with some negative values and on the right side
the modified results if I use fabs( sum(score)/count(name)) or RangeAvg(fabs(score)).

How can I keep the scores unchanged and also show the average value of them in my expression?

[marcus_sommer · Accepted solution]

You don't mentioned the place and context in which the values/results should be displayed. Therefore various approaches are thinkable, for example:

• adding an extra field with positive/negative information
• using dual() values, like: dual(value, fabs(value))
• querying the dimensionality in a pivot, like if(dimensionality() = 0, fabs(value), value)

- Marcus

[PrashantSangle]

Use fabs() inside sum()

 sum(fabs(score))/count(name)

Regards,

[17George]

Thanks @marcus,
both suggestions, dual( ) & dimensionality() worked as desired in my table.

Is there a possibility to adjust the  results according to the weighted factor of +/- signs?
For example: avg (-3, -7) = 5 and sum(-3,-7) = -10. 
Since the negative sign is overweighing,  -5  might be adopted  as "adjusted" average.

[marcus_sommer]

I'm not sure what you mean with an adjusted average but both in the origin question mentioned methods may be adaptable for it - means: sum() / count() and/or rangeavg() - directly or combined with an aggr(), maybe like:

avg(aggr(sum() / count() , Dim1, Dim2))

or

rangeavg(aggr(only(Value), Value))

- Marcus