I would like to make a Ref_Rows formula that shows all related transfer requests for specific Equipment IDs. However I can’t make the Equipment ID’s the key of the transfer requests but I can make it the label. The current formula is: REF_ROWS(“Transfer Log”, “Equipment ID:”) which returns blanks because as the test shows:
The list of values of column ‘Key:’
…from rows of table ‘Transfer Log’
…where this condition is true: ((The value of column ‘Equipment ID:’) is equal to (The value of column ‘Key:’))
It should say:
The list of values of column ‘Equipment ID:’
…from rows of table ‘Transfer Log’
…where this condition is true: ((The value of column ‘Equipment ID:’) is equal to (The value of column ‘Equipment ID:’))
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |