Forum Discussion

Winss's avatar
Winss
Qrew Trainee
5 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 relation...
Relationships
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
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
    5 years ago
    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
    ------------------------------