Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Easy Calculation

Hi @ all,   I would like to calculate the following: "Workload Person/Activity"   Person                            Activity                  Workload                                   Workload P...
Need Help
  • petrovnikitamai's avatar
    petrovnikitamai
    7 years ago
    new column = sumx(filter(TableName;earlier([Person])=[Person]&&earlier([Activity])=[Activity]);[Workload])

    try this

petrovnikitamai's avatar
petrovnikitamai
Resolver V
7 years ago
new column = sumx(filter(TableName;earlier([Person])=[Person]&&earlier([Activity])=[Activity]);[Workload])

try this

Anonymous's avatar
Anonymous
Not applicable
7 years ago

works perfectly, thanks!