Get the Total Absolute Value Difference Based on Item Context (Not Total)

[former_member385923]

Hi WebI gurus,

Could you help me get the difference by individual DIM context?

For example (attached screenshot) samplexlsx.png

BO gives out the total difference of "-10" and not "50".

I've tried adding context by adding "in" but still with no luck.

Hope to hear your thoughts or suggestions.

Warm regards,

- Louis

[former_member385923 · Accepted solution]

=Sum(Abs([Value1] ForEach([Item]) - [Value2] ForEach([Item]) ))