Iโve got this expression:
SELECT(
OrderMaandBudgetten[_ROWNUMBER],
([_THISROW].[Order ID] = [Order ID])
)
Iโm looking for a list of rownumbers which correspond to the current row based on Order ID.
However, right now it returns just one rownumber. This rownumber had the right Order IDโฆ still there are more rows with the same Order ID which it doesnโt return.
What am i missingโฆ
Solved! Go to Solution.
list doesnโt have any valid if expression. Configurations also seemed right. Itโs not a slice.
However, I forgot there was a security filter on OrderMaandBudgetten, making the output validโฆ
Thanks @Steve. I changed the security filter and the problem is solved now!
Hello Donny, try this please:
SELECT(
OrderMaandBudgetten[_ROWNUMBER],
([Order ID] = [_THISROW].[Order ID])
)
Hi Rafael, tried that already but still returning just one valueโฆ
Thatโs weird, the function is being used as stated in the documentation, the only advice i can give you is to recheck your Order ID column, but iโm pretty sure you have already done that, so iโm calling for backup @Steve
Yes. Hopefully @Steve knows the answer. Order ID column looks fine. Iโm stuck at this moment
Your expression looks fine. How are you using the expression? In an App formula? In an Initial value? As part of some other expression? Please post a screenshot of the expression as itโs being used.
Please also post a screenshot of the OrderMaandBudgetten data (spreadsheet?) demonstrating multiple rows with the same Order ID value.
Hi Steve,
The expression is part of another expression. I broke down this formula and saw that this part is the bottleneckโฆ So I tried this part of the bigger formula alone.
Below the OrderMaandBudgetten table (spreadshseet). Highlighted the full Order ID, indicating that there are three matches.
I use the expression as app formula in a virtual column (see below). As you can see circled in red, for that particular order, it just returns the first match row number 10. However, I also expect number 25 and 32.
The original formula is stated below, returning the wrong value because the select function doesnโt return multiple values.
Does the OrderMaandBudgetten table have a security filter? Or is it a slice?
Does the list column have a Valid If expression?
Please post a screenshot of the configuration screen of the list column down to and including the Type Details section.
list doesnโt have any valid if expression. Configurations also seemed right. Itโs not a slice.
However, I forgot there was a security filter on OrderMaandBudgetten, making the output validโฆ
Thanks @Steve. I changed the security filter and the problem is solved now!
Bingo! Well done!
User | Count |
---|---|
37 | |
26 | |
23 | |
17 | |
14 |