Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
yanivvl0
Creator III
Creator III

How to sum sub level by dates ?

hi to all ,

i have projects , and in a project can be some books , each book has amount of unitss , and each project make savings of units.

i need to sum for a save-date of project the saved units until the save-date , and also the book-units that have any step until the save-date. 

for example in this project for save-date 1/1/2016 there is 2 saved units , but no book units bcause any of the tree books has a step beffore 1/1/2016 .

for example in this project for save-date 1/6/2016 there is 15 saved units , and 104 book units bcause all of the tree books has a step beffore 1/6/2016 .

project books steps save.PNG

i need to see project - save-date - saved units - book units  .

THANKS !

15 Replies
yanivvl0
Creator III
Creator III
Author

HI Sunny , again I highly appreciate the professional help you give !!

sunny_talwar

No problem my friend...

yanivvl0
Creator III
Creator III
Author

HI Sunny , i found a little err in sum (save units) , at the yellow marks the aggrigation Resetting :exmple prjbook_dates_sums 3.PNG

sunny_talwar

I am not seeing this

Capture.PNG

yanivvl0
Creator III
Creator III
Author

my mistake ,,

sunny_talwar

What was wrong?