Skip to Content
avatar image
Former Member

WEBI 4.1 context issue

Hi, need help in creating a formula.

I have 2 measures and a dimension.

say Measure = M1, M2

Dimension = D1

I need Absolute(M1+M2) where Absolute(M1+M2)>100 foreach D1, this output I need in a cell.

exmaple:

D1 M1 M2 M1+M2 Abs(M1+M2) Abs(M1+M2)>100

ABC -90 -40 -130 130 130

XYZ -30 10 -20 20 0

PQR -120 10 -110 110 110

Output required:

130+110 = 240 (in a cell)


I am currently using below formula , however getting incorrect result, need your help.

if (Abs(M1+M2)>100;sum(Abs(M1+M2)>100 foreach (D1));0)

Thanks

Sonam

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 09 at 01:27 PM

    try with these steps.

    First make sure M1 and M2 should be dimension objects.If not create two dimension variables for these.

    After that use below formula.

    =Sum(Abs([M1]+[M2]) Where (Abs([M1]+[M2]) >100)) ForEach ([D1])

    Add comment
    10|10000 characters needed characters exceeded