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.
Re: Create a new line item to be max of old line item
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.