Sum of distinct Vales from Table.

[former_member593850]

Hi All.,

This is extension question for Previous Post
I was not able to edit the question thus starting new thread,

My requirement is I need to fetch all Distinct vale from table and sum it up.

Source

And Op I need is- (where Column B is not required)

Can some one please help.

[former_member593850]

Source-

Destination-

[Tom_N8 · Accepted solution]

Hi Ayush,

Thanks for clarifying your changed requirement.
Change the formula to: =Sum(Max([Col C]) ForEach([Col B])) In([Col A])

Kind regards,

Tom

[former_member593850]

Hi Tom,

Ok you might have replied on this before I modified my question,
Same is working fine for me if Col A is having single type of entry.
But if you see updated question Column A do have different set of data, and that is where count is not correct.

[Tom_N8]

Hi Ayush,

Maybe you can rephrase your question again and state your desired result? Your screenshots do not display anymore.

Thanks,

Tom

[former_member593850]

Hi Tom,

Thanks for ur support.

But the formula is giving total count
if we consider above example it is giving (15+14) 29

[Tom_N8]

Hi Ayush,

Works for me:

Regards,

Tom

[Tom_N8]

Hi Ayush,

Try creating a new variable with the following formula:

=Sum(RunningSum([Col C];([Col B]))) In Block

This will return the desired result and also works for your previous example, provided you only have one distinct value for your values in Column B. As with your previous question, replace [Column C] with the new variable and then hide [Column B] from your table block.

This formula also works for your previous question.

I also recommend downloading the "Using functions, formulas and calculations in Web Intelligence" documentation from the SAP Help portal.

Kind regards,

Tom