Hi I was wondering if someone could help me verify this template expression? I canโt get it to return anything. The exact same expression return values in the editor. I canโt figure out what I am missing
<<Start: [Related Job Activities]>>
<<TOTALHOURS(SUM(SELECT(Job Activity[Duration],[Production Id]=[_THISROW].[Production Id])))>>
<<End>>
Solved! Go to Solution.
Can you try this:
TOTALHOURS(SUM([Related Job Activities][Duration]))
Can you try this:
TOTALHOURS(SUM([Related Job Activities][Duration]))
That did the trick. thank-you.
However, what if I want to take the same expression and drill down? For example,
<<Start: [Related Job Activities]>>
<<TOTALHOURS(SUM(SELECT(Job Activities[DURATION],AND([Production Id]=[_THISROW].[Production Id],[Production Assignment]=[_THISROW]."Packaging")))) >>
<<End>>
I would have to use a SELECT expression, correct?
Lastly, can you explain why my original formula didnโt work so I know the limitations of template expressions?
I donโt know why your original formula did not work.
As to how to drill down, if there are not too many cases, I would create slices of the Job Activities table and add another VC similar to [Related Job Activities] which is probably a REF_ROWS(โJob Activitiesโ,โKeyColโ) formula referencing that slice - i.e., REF_ROWS(โJob Activities Sliceโ,โKeyColโ)
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |