Register

Line Item Subset Summary Level, workaround needed please!

dsoomar002
Certified Master Anaplanner

Line Item Subset Summary Level, workaround needed please!

Hello,

 

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. 

 

Number1

Number2

Number3

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

Actuals:

Number1= 10

Number2= 10

Number3=15

Number4=35 (10+10+15) 

 

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.

14 REPLIES 14
dsoomar002
Certified Master Anaplanner

Re: Line Item Subset Summary Level, workaround needed please!

Tagging @JaredDolich @Misbah @rob_marshall in case if you have any suggestions. 

rob_marshall
Moderator

Re: Line Item Subset Summary Level, workaround needed please!

@dsoomar002 

 

Is the IsSummary checkbox turned on (True) in the bluepirnt where the line items are originally created?  If so, uncheck that.

 

2021-04-23_09-16-32.png

 

Rob

Misbah
Moderator

Re: Line Item Subset Summary Level, workaround needed please!

@dsoomar002 

 

Just turn the summary option off (by disabling then Boolean in Blue print view of that module) for Number 4 line item

 

Misbah_0-1619187430912.png

 

.That should fix it

 

Misbah

rob_marshall
Moderator

Re: Line Item Subset Summary Level, workaround needed please!

@Misbah 

 

HA!!!!  You are too late!

Misbah
Moderator

Re: Line Item Subset Summary Level, workaround needed please!

@rob_marshall 

 

Late, because I was creating Screenshots for @dsoomar002 .You have everything ready.

dsoomar002
Certified Master Anaplanner

Re: Line Item Subset Summary Level, workaround needed please!

@Misbah @rob_marshall - you both were mighty fast...but i'll give you guys another chance 🙂 

 

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 checkboxWith checkboxWith Checkbox, number 4With Checkbox, number 4With Checkbox, number 3With Checkbox, number 3Number 4 selected, does not return anythingNumber 4 selected, does not return anythingNumber 3 selected, works just fine with or without checkboxNumber 3 selected, works just fine with or without checkboxNo checkboxNo checkboxNo checkboxNo checkboxNo checkboxNo checkbox

rob_marshall
Moderator

Re: Line Item Subset Summary Level, workaround needed please!

@dsoomar002 

 

I guess I am not understanding because the Lookup works fine for me:

 

2021-04-23_10-29-00.png

 

2021-04-23_10-29-16.png

 

2021-04-23_10-29-30.png

 

dsoomar002
Certified Master Anaplanner

Re: Line Item Subset Summary Level, workaround needed please!

Hey @rob_marshall @Misbah @AntonMineev,

 

I just recorded a video capturing the situation, it's about 2 mins. Hope this helps explain the issue clearer. See attached. 

 

 

rob_marshall
Moderator

Re: Line Item Subset Summary Level, workaround needed please!

@dsoomar002 

 

You missed the collect piece, I believe.  Check this out...

 

2021-04-23_12-09-09.png2021-04-23_12-09-22.png2021-04-23_12-09-50.png2021-04-23_12-09-59.png2021-04-23_12-10-09.png2021-04-23_12-10-18.png2021-04-23_12-10-43.png2021-04-23_12-11-00.png