Sum from 2 rows

[former_member399534]

Hello all,

I m trying to sum 2 figures in the same block base on my scenario and criteria

attached. However, I cannot get the sum results but only sum of each row not

the sum of the 2 rows together which is actually what I wanted. Would u hint

me on where to start solving this problem.

I have already put the formula in the attachment... but seems to no avail..

THe actually value I want on the HK ReClass field shud be the sum = 203270.32 + 2802491.52 = 3005761.84

I m using Webi XI 3.0 or DeskKI.

THanks

Clement

<!--

/* Font Definitions */

@font-face

{font-family:ËÎÌå;

panose-1:2 1 6 0 3 1 1 1 1 1;}

@font-face

{font-family:"@ËÎÌå";

panose-1:2 1 6 0 3 1 1 1 1 1;}

/* Style Definitions */

p.MsoNormal, li.MsoNormal, div.MsoNormal

/* Page Definitions */

@page Section1

div.Section1

-->

=If(

&lt;&gt;&quot;116875&quot; And &lt;&gt;

&quot;210976&quot; ) Then &quot;&quot;

 Else ( Sum(

 Where( InList (&quot;116875&quot;;&quot;210976&quot;))))'

[former_member399534]

Hello Ishaq and GodBlessme,

I used NoFilter (sum of balance ([dimension] where [dimension] inlist (value1, value1) )) and it works.