How to write formula in DV to get similar like sumif function in excel?

3473493

Summary

How to write formula in DV to get similar like sumif function in excel?

Content

Hello,

 

Can anyone help me to write sumif formula in DV to get the require output? Not able to get the right syntax/formula in calculation option? Thank you

[Deleted User]

case when 1=2 then SUM(imagination) else sum(sales) end

3473493

I am still not sure on this formula...I am looking for example ..there are 1000 ID's against each ID there will be value and in these ID's there are lot of repetitive in nature hence, I should get the sum total for ID....if 10 same ID's then I should get the sum of all 10 ID's in all ten rows....in below table result column exactly what I need it...

 

ID	Amount	Result
1	100	600
1	200	600
1	300	600
3	900	900
4	250	250
5	900	1750
5	850	1750
7	220	430
7	210	430

Thanks for your time....

[Deleted User]

Would have helped to have that information right from the start.

SUM(x by y) would be an appropriate solution.

Luke Sharma

Hi there,

I think  you need to use a "SUM by" function to get this output e.g. I used SUM(Amount by ID) as a calculation  to get the required output (as seen in screenshot)