Hi,
I am trying to generate every weekday using the end of week and beginning of week.
However when I summarize my data at the end of the year I am seeing Louis Stevens not having dates but Matt Smith having dates available.
I would expect them both to have equal number of dates. As you can see only Matt Smith has late december dates.
see attached workflow.
Solved! Go to Solution.
The problem is in the formula of the mult row tool.
When you change the name to Matt the formula is wrong.
The correct formula might be this:
IIF(isNull([Row+1:date] ) or [Staff Name] != [Row+1:Staff Name],DateTimeTrim([date],'LastOfMonth'),DateTimeAdd([Row+1:date],-1,'day'))