I will do my best to express what I’m asking and what I tryed to do.
Giving more information for it.
I only have 1 Table it’s called “Performance” in this table I want to add every hour how many "Thins
" (Exactly how many boxes) an employee “Someone” has finished.
So, when in the next hour I’m going to add more boxes to someone I want to acomulate te total value for this person
The Data I’m Using is:
Sower Type: Ref - (to bring the information from a sowers database)
Amount of seeds Type: Number - (This is the information that they will fill every hour
Accumulated seeds Type Numer - Inthis is where I’m trying to acomulate the values
- I started with the Select because it was my first thought. And ofcourse it didn’t work due to the condition for sowers it’s always true.
- At the moment i’m trying using the most recent value in this way:
Most Recent = maxrow(Performance, Date Time, [Sower] = [_THISROW].[Sower])
Data [Most Recent] = REF_ROWS(“Performance”, “Most Recent”)
And in the formula of [Accumulated seeds] = [_THISROW].[Amount of seeds] + [Most Recent].[Amount of seeds]
But in this way is not agregating the values, it is replacing the values for the most recent
PD: I’m sorry if my english is not the best, I tryed to explan as best as I can