I stucked with building sum formula, when I look for values from existing tables.
Lets say - I have a main table with tasks (columns: Tasks -plain text; Project -lookup for another table with project description; Taken time - duration) and a summary table (with project name and total duration columns). I want to calculate a sum from duration column with filter for thisrow.project, but the formula is not working. My formula examples:
1)= TASKS.taken time.filter (tasks.project = thisrow.project).sum();
2) = lookup (tasks, taken time, thisrow.project).sum()
Please let me know if you know what’s wrong here.