I am trying to put the calorie total (group aggregate) for the day that is from one table in the calories consumed field of other table for the same date but getting the error "Cannot compare List with Date"
Trying to use a virtual column in the daily sum table where the data needs to go.
Is there a hidden sum function for the group aggregate number I can access to get this number to make this easier?
Solved! Go to Solution.
It should be [date]=[_thisrow].[date]
It should be [date]=[_thisrow].[date]
Thanks! That worked.
User | Count |
---|---|
32 | |
30 | |
30 | |
18 | |
16 |