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.
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.
Unfortunately, turning off the checkbox does not get me the result I need. I think @AntonMineev may be onto something. See screenshots attached of my full setup...I am not getting the result I need with the summary checkbox turned on or off.
I also tried adding + 0 or +.000001 and that did not help either. I may need some of those more complex workarounds 🙂
Again the goal is to see 35 in the Summary report.
With checkboxWith checkboxWith Checkbox, number 4With Checkbox, number 3Number 4 selected, does not return anythingNumber 3 selected, works just fine with or without checkboxNo checkboxNo checkboxNo checkbox