Hi,
I'm trying to add data that has been calculated in Module A to module B.
Module A:
- List 1
- Time
- Line items, where one of them is: Account XPTO1 (data's format is number), Account XPTO2 and Account XPTO3
Module B:
- List 1
- Time
- List 2 (where we have accounts)
- Line items, where one of them is: Final Value (data's format is number)
What we want to do is give values that we calculated in Module A, line item Account XPTO to the line item Final Value of module B.
What we have tried:
1 - Final Value formula has ifs saying: IF ITEM (List 2) = LIST 2.Account XPTO1 THEN MODULE A. Account XPTO1 Else ….
Error: List 2 are marked as production data and couldn't be referenced
2 - created a Module A1
Module A1
- List 1
- Time
- Lis Subset of List 2, where we only have account XPTO1, XPTO 2and XPTO3
- Line items:
- Mapping (data format: List 2) and we associated the 3 accounts to Account XPTO1, Account XPTO 2 and Account XPTO 3
- Data ( data format: number): formula= COLLECT()
How can we do this ?
Thank you in advance,
