Forum Discussion
Conditional column result returns a list – should return a value
Hi, I have the below formula, where if the condition is met the result is pulled from the other query which is also loaded in the same excel workbook. The result should be a single value, but it retu...
Hi apoje
That step will not result in a single value. Your iterating over each row in the column [OrderDate.date] so you end up with a column.
What exctly are you trying to do? Why do expect the result to be a single value?
Please supply the data too otherwise I'm just guessing at what you are working with.
Phil