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

Question

Summary

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] · Answer

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

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

Luke Sharma · Answer

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)

3473493 · Answer

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...

IDAmountResult11006001200600130060039009004250250590017505850175072204307210430

Thanks for your time....