Create a new line item to be max of old line item

jsong
New Contributor

Create a new line item to be max of old line item

This might be a silly question, but I just got stuck and couldn't think of a solution. I want to create a new line item showing the max of an existed line items. Take the example below, I want to create a new line item called max days, which takes the max of Days. 

Original:

        Days

A        1

B        2 

C        3

D        4

New:

        Days     Max Days

A        1                4

B        2                4

C        3                4

D        4                4

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
LipChean_Soh
Certified Master Anaplanner

Re: Create a new line item to be max of old line item

Hi Jsong,

 

You can try the following.

Note the summary method of 'Value'.

 

Thanks,

LipChean

 

Screen Shot 2019-03-13 at 2.40.30 PM.pngScreen Shot 2019-03-13 at 2.40.38 PM.png

View solution in original post

6 REPLIES 6
LipChean_Soh
Certified Master Anaplanner

Re: Create a new line item to be max of old line item

Hi Jsong,

 

You can try the following.

Note the summary method of 'Value'.

 

Thanks,

LipChean

 

Screen Shot 2019-03-13 at 2.40.30 PM.pngScreen Shot 2019-03-13 at 2.40.38 PM.png

View solution in original post

jsong
New Contributor

Re: Create a new line item to be max of old line item

Thank you so much!

ArunManickam
Master Anaplanner/Community Boss

Re: Create a new line item to be max of old line item

@LipChean_Soh ,

 

This solution works nicely.

 

Lets say in case I cannot have a summary as MAX, I could create another line item and set the summary to MAX.

 

Is there any alternate solution to it, I tried to use the aggregation function MAX using the TOP level of the list. Its not working.

 

 

 

Thanks

Arun

ArunManickam
Master Anaplanner/Community Boss

Re: Create a new line item to be max of old line item

Untitled.jpg

LipChean_Soh
Certified Master Anaplanner

Re: Create a new line item to be max of old line item

Hi Arun,

 

In X[Max:Y], Y refers to the lists of which you want to first segregate your 'X', before finding the largest 'X' to be assigned to different members of Y.

 

I'm interested to find out why you cannot use 'Summary = Max' with Value. 

 

Having said that, i created something below that utilizes a list with a single member, but i highly discourage creating single member list since it's normally the first step towards creating some super customized solution that isn't scalable or maintanable.

 

Thanks,

LipChean

Screen Shot 2019-03-14 at 2.02.01 PM.pngScreen Shot 2019-03-14 at 2.02.08 PM.pngScreen Shot 2019-03-14 at 2.05.37 PM.png

ArunManickam
Master Anaplanner/Community Boss

Re: Create a new line item to be max of old line item

@LipChean_Soh 

Thanks. Yes, I agree that we should not have a single member list.

Thats why I was trying to use top level, I was not sure why the aggregation function is not working at the top level.

 

Thanks

Arun