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

Accepted answers

LipChean_Soh

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.png

All comments

LipChean_Soh

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.png

jsong

Thank you so much!

ArunManickam

@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

LipChean_Soh

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.png Screen Shot 2019-03-14 at 2.05.37 PM.png

ArunManickam

@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

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…