Sum from 2 rows

[#1]

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 Member]

I am sorry that I do not understand your requirements clearly. But I am trying to make a guess and provide you a hint to find the answer.

I assume that you want to display the value {3005761.84} in "HK Reclass" column (both the rows). This can be achieved by using Calculation Contexts.

Just try to use Sum([Sum of Balance]) In Body

Thanks & Regards,

Mohanraj CP

http://blog.mohanraj.org