Forum Discussion

Applicable88's avatar
Applicable88
Impactful Individual
5 years ago
Solved

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...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • HotChilli's avatar
    HotChilli
    5 years ago

    This is a bit of a guess.  Replace 

    Ordertable

    in the formula with the previous step name  like ......      #"whatever"

Anonymous's avatar
Anonymous
Not applicable
5 years ago

You may wish to wrap each if clause in parentheses so there is not chance of PQ getting confused, like this:

([ProductiveWorkday] = 1) and ([OutboundDate] > Date.From(DateTime.LocalNow()))

 

 

Applicable88's avatar
Applicable88
Impactful Individual
5 years ago

Hi Anonymous , thanks again for your effort. I also tried to leave the ProductiveWorkday out completely. Didn't help. But I think the tip of HotChilli is going into the right direction.