Forum Discussion
Applicable88
5 years agoImpactful Individual
Cannot spot Syntax failure/list min query
Hello, I made a calculated column for this table: 11.05.2021 Tuesday 1 1234 12.05.2021 Wednesday 1 1235 13.05.2021 Thursday 1 1236 14.05.2021 Friday 1 1237 15.05.2021 Sa...
- 5 years ago
This is a bit of a guess. Replace
Ordertablein the formula with the previous step name like ...... #"whatever"
HotChilli
5 years agoCommunity Champion
This is a bit of a guess. Replace
Ordertable
in the formula with the previous step name like ...... #"whatever"
Applicable88
5 years agoImpactful Individual
Hey HotChilli, thanks so much... this was it!
It was a perfect "guess":)
I really want to learn from this mistake, so can you explain
why it doesn't work with the orginal table name but with the #"StepName" ?
I also want to mention that the ProductiveWorkdays column is originally from a separated mastercalendar
that I joined with the maintable so I can use this as a condition for my statement. I don't know if that plays a role?