Forum Discussion

ricardo9's avatar
ricardo9
New Member
2 years 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
    2 years ago

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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

ricardo9's avatar
ricardo9
New Member
2 years ago

As i said it wont happen because de order does not accept the same product

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    I don't know what that means.  Both orders 1 and 3 have two products. why can order 2 not have two products?

    • ricardo9's avatar
      ricardo9
      New Member
      2 years ago

      Just can't be the same product, a order can have a lot of products

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        What is the expected outcome for 

         

        Product      idorder

        Product A   1
        Product B   1
        Product A   2
        Product C   2
        Product A   3
        Product C   3
        Product C   4
        Product A   5
        Product A   6