LookUp() not pulling from secondary dataset

LookUp() not pulling from secondary dataset

Posted by: rdillon on 26 June 2023, 5:17 am EST

• 

  rdillon

  • Post Options:
  • Link
    Copy

  Posted 26 June 2023, 5:17 am EST - Updated 26 June 2023, 5:22 am EST

  We have a data set Receipts. All the records have a State field. One record in each State group has a Level name of “Undistributed”. I have made a second data set (ReceiptsUndistributed) from the source and applied a filter to just have 1 Undistributed record for each State. I try to use the LookUp function to pull the balance for the Undistributed record but the result is just the First record’s Balance in the original dataset for the current State group.

  This is like the expression used:

  =Lookup( Fields!State.Value ,  Fields!State.Value, Fields!Balance.Value, "ReceiptsUndistributed")

  So based off the data below, it always returns Tennessee’s value of 40 in that group and Kentucky’s value of 33. Neither of which are in the second dataset.

  Does LookUp not work with Filtered datasets?
  
  Thank you for any advice you can offer.

  

• 

  akshay.rajput

  

  • Post Options:
  • Link
    Copy

  Posted 27 June 2023, 2:57 am EST

  Hi Renee,

  As far as I know this is a limitation of the Lookup function. However, just to be sure I have asked the development team for some insights on this. I will let you know once I have any information on the same.[AR-29361]

• 

  rdillon

  • Post Options:
  • Link
    Copy

  Posted 27 June 2023, 4:19 am EST

  Thank you, I appreciate the help.