Line Item Subset Summary Level, workaround needed please!
I have run into an issue for which I could not find any documented limitation or bug, but I think I may have hit one. I am looking for a solution to the following scenario:
Let's say I have a constants module, ModuleA, that I am driving a LISS off of.
Number4 = (Number1+Number2+Number3)
Let's create a LISS from the 4 numbers above. We can call it LISS Numbers.
I have a module, Module B, where I can load in data into each line item, (List 1 (top level: All List Members) x LISS Numbers x Line Item (amount) x Versions x Months).
Top level: All List Members
Now I want to pull Number 4 into Module C, which is: Versions x Months x Line Items (Number4summary)
Number4summary = ModuleB.Amount[LOOKUP: SYS00 LISS Lookup Module.Number4]
SYS00 LISS Lookup Module.Number4 is a System Constants Module with a List Formatted Line Item (LISS Numbers Format) that is selected as Number 4.
The problem I am running into is the model is not interpreting this at all. So I am returning 0. The funny thing/interesting thing is, if I change the dropdown from Number 4 to Number 3, I am able to return 15 or when I choose Number 2, I am able to return 10 successfully. The LOOKUP fails only when I select Number 4 in the constants module dropdown.
Does anyone have any workarounds? Is this a limitation of a LISS? That you cannot lookup summary line items? This should be pretty easy to replicate in a playground environment.
Now I could do something like:
Number4summary= ModuleB.Amount[LOOKUP: SYS00 LISS Lookup Module.Number1] + ModuleB.Amount[LOOKUP: SYS00 LISS Lookup Module.Number2] + ModuleB.Amount[LOOKUP: SYS00 LISS Lookup Module.Number3]
However, again, I would much rather just pull Number 4 and just refernce the total once, rather than recalculating the total. My real scenario has about 65 numbers on the actual scenario so doing that kind of aggregation manually would be painful, but would prefer not to. And there are also a few more intermediary modules where some additional math or overrides can get applied to the LISS, but this is the oversimplified example.
Any help here would be appreciated, looking for a response on a fairly quick timeline for a client.