Forum Discussion

ricardo9's avatar
ricardo9
New Member
1 year ago
Solved

Cumulative that reset

Hey everyone, I need to sum a cumulative way that will stop at some point and reset the sum: Example: Product          idorder       repeat       new column * Product A          1                ...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

     

lbendlin's avatar
lbendlin
Super User
1 year ago
So if the same products repeat in the next id order

That's too vague.   Did you mean to say "if any product repeats across orders"?  What if order 2 had product C as well?

ricardo9's avatar
ricardo9
New Member
1 year ago

it can't, the id order doesn't repeat the product

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

     

    • ricardo9's avatar
      ricardo9
      New Member
      1 year ago

      not correct, i need to create New Column* that i put there

      • lbendlin's avatar
        lbendlin
        Super User
        1 year ago

        as I said, the requirement is too vague. What if Product C is part of idOrder 2 ?  What would be the expected result?