So I have a formula for a column to grab the associated District_ID to my requisition. When I’m using a lookup I get 1 which is incorrect but if I use ANY(SELECT()) I get 2 which is correct.
Am I just being stupid that these 2 formulas are not semantically the same? I even added a [_THISROW] to my lookup and still got the wrong value.
LOOKUP([REQUISITION_ID],“REQUISITION”,“REQUISITION_ID”,“DISTRICT_ID”)
ANY(SELECT(REQUISITION[DISTRICT_ID], [REQUISITION_ID]=[_THISROW].[REQUISITION_ID]))
Solved! Go to Solution.
This:
LOOKUP([REQUISITION_ID],“REQUISITION”,“REQUISITION_ID”,“DISTRICT_ID”)
is equivalent to this:
ANY(SELECT(REQUISITION[DISTRICT_ID], ([REQUISITION_ID] = [REQUISITION_ID])))
which is equivalent to this:
ANY(SELECT(REQUISITION[DISTRICT_ID], TRUE))
which is equivalent to:
ANY(REQUISITION[DISTRICT_ID])
This:
LOOKUP([REQUISITION_ID],“REQUISITION”,“REQUISITION_ID”,“DISTRICT_ID”)
is equivalent to this:
ANY(SELECT(REQUISITION[DISTRICT_ID], ([REQUISITION_ID] = [REQUISITION_ID])))
which is equivalent to this:
ANY(SELECT(REQUISITION[DISTRICT_ID], TRUE))
which is equivalent to:
ANY(REQUISITION[DISTRICT_ID])
Coulda sworn I put the [_THISROW] in my formulas and they weren’t working…now they do and the initial formula is now working because I have the correct formula as well…I guess I just know nothing and need a break.
Been there, done that.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |