Forum Discussion

Winss's avatar
Winss
Qrew Trainee
4 years ago

How to create cumulative sum based on a parent Item

I have 2 tables Actors and Movies. Actor have fields like Actor name, Dob. Movies have fields like Boxoffice Collections, Movie name, Cumulative collections. Actor and Movies have one to many relationship. One Actor many Movies.  I want to get the cummilative collection based on the Actor-actor name in the child table Movies. 
Example:
Actors
Actor Name DOB
Williams 04-Mar
Jason 05-Jun

Movies
Movie name BoxOffice Collection Actor Name Cummilative Collections
One Night 10 Williams 10
At the call center 25 Williams 35
Kumbalangi 20 Jason 20
Roja 30 Williams 65
Chichore 15 Jason 35


------------------------------
Aswin Babu
------------------------------
  • I'm not certain I understand what you're trying to do. Can you provide an example of the output you're expecting?

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • Winss's avatar
      Winss
      Qrew Trainee
      In the example i have tried to show what i need. If you look movies table you can see a column cumulative collections, it adds the value of box office collections of previous record based on the parent table - actor name.

      ------------------------------
      Aswin Babu
      ------------------------------
  • Winss's avatar
    Winss
    Qrew Trainee
    If someone has an idea to do it, please reply

    ------------------------------
    Aswin Babu
    ------------------------------