Look up question
Best Answers
-
In Module 1 apply this formula to check that it's working:
'Module 2'.'OPP #'[SUM: 'Module 2'.'Account ID', SUM: 'Module 2'.'Close Date', LOOKUP: 'Module 2'.'Close Date'
The combination of SUM and LOOKUP is never recommended as it affects model performance. So if the above works, as a next step, create a new line item dimensioned by Day and Account ID and in that line apply:
'Module 2'.'OPP #'[SUM: 'Module 2'.'Account ID', SUM: 'Module 2'.'Close Date']
And then in Module 1 apply:
New Line Item[LOOKUP: 'Module 1'.Close Date]
0 -
In Module 1 create an Oppcode list formatted line item, and do a lookup with that line item.
For your reference,"'Module2'.Opp#[LOOKUP: Oppcodelist]"
Hope it works
0 -
Hello @Shiva Honnalli , What if Module 2 is a transactional data and has multiple occurrences of Account
In that case, LOOKUP will not provide required result but SUM does.
Thanks,
Vamsi
0
Answers
-
0