I want the value of the [PACKET TYPES] if the value matches with [awb no]. But here the function is not working.
AND(
NOT(
ISBLANK(
ANY(
SELECT(
check[PACKET TYPES],
STARTSWITH([_THISROW].[AWB NO], [Start])
)
)
)
),
NOT(
ISBLANK(
ANY(
SELECT(
check[PACKET TYPES-2],
ENDSWITH([_THISROW].[AWB NO], [END])
)
)
)
)
)
Solved! Go to Solution.
So you want to retrieve a text value and not a yes-no value.
Assuming you do NOT have cases where both start and end values match then you can try
CONCATENATE(
ANY(
SELECT(
check[PACKET TYPES],
STARTSWITH([_THISROW].[AWB NO], [Start])
)
),
ANY(
SELECT(
check[PACKET TYPES-2],
ENDSWITH([_THISROW].[AWB NO], [END])
)
)
)
If you do have cases where both start and end values match, you get a concatenated string of PACKET TYPES and PACKET TYPES-2.
Your expression evaluates to TRUE for the [awb no] of value "5132....TCQ".
I believe what you want is
ISNOTBLANK(
SELECT(
check[PACKET TYPES],
AND(
STARTSWITH([_THISROW].[AWB NO], [Start]),
ENDSWITH([_THISROW].[AWB NO], [END])
)
)
)
So you want to retrieve a text value and not a yes-no value.
Assuming you do NOT have cases where both start and end values match then you can try
CONCATENATE(
ANY(
SELECT(
check[PACKET TYPES],
STARTSWITH([_THISROW].[AWB NO], [Start])
)
),
ANY(
SELECT(
check[PACKET TYPES-2],
ENDSWITH([_THISROW].[AWB NO], [END])
)
)
)
If you do have cases where both start and end values match, you get a concatenated string of PACKET TYPES and PACKET TYPES-2.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |