BPC 10MS - OLAPLOOKUP

[Former Member]

HELLO,

I need to lookup value for 2 accts and for different quarters. lookup works when  I have only one accts and a for loop for quarters.

it doenst work when I add another for loop to lookup value for the second acct. anything wrong with the syntax?

[former_member186498 · Accepted solution]

Hi Meghana,

can you please share the error message you received?

for sure the lookupId cannot be a variable must be a single name so you have to declare more rows.

Regards

     Roberto

[Former Member · Accepted solution]

NO ERRORS ..JUST NOT RETURNING ANY RECORDS  WHEN I ADD THE SECOND ACCOUNT AND A FOR LOOP FOR IT.

I WORKS WHEN I HAVE ONLY ONE ACCT IN THE LOOKUP

[Former Member · Accepted solution]

resolved by modifying  code as below