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

</html>

I have found this solution to be working... THanks for all ur guys comments...!

Thank you so much for the help! Perhaps i didnt' state clearly my problem definition.

There will be more than 2 account codes in the Hkacctcode column. therefore, if i want to

sum up only selected rows's total sales, I cant achieve this by using

because this would only bring up each row''s sum only even though I specify the criterion for summation, it didnt follow - maybe due to filters.

=Sum([Sum of Balance]

Where([Hkacctcode] InList ("116875";"210976")))

And I tried this morning agian this the following and it worked..!

=NoFilter( ( Sum([Sum of Balance]

Where([Hkacctcode] InList ("116875";"210976"))) In Report ) ; All)

I can bring individual values to row total depending on my criterion regardless of filter and summation rule.