Getting the maximum value

Hi, Could you tell me how to get the maximum value of a line item? I would like to get the maximum value of the 'Number of Days' line item in the attached screenshot. ('Seq No.' list is applied to Row and Line item is applied to Column in this module.) Best regards, Maki Yasuda

5290197_1517.png

Accepted answers

All comments

hendersonmj

1) Make sure your List has a Top Level member set.
2) Use the Summary setting for your Line Item, set summary to Max.
3) In the formula where you need the max value, use <line item>[ SELECT: <list name>.<top of list> ]

And if you really need your line item to still sum, you'll need to create a second line item with a name like "Max <your line item>" just for this purpose with the formula: <line item>.

Quick Links

Can you help?

Unanswered questions

Importing from Data Hub: Incorrect or Missing Mappings in Target Model
When importing data from a Data Hub to another model, I'm seeing values in the target model that don't exist in the source. For example, seller assignments are being tagged with subregions that aren't present in the source data - some assignments are missing expected tags, while others are mapped to seemingly random…
ANAPLAN XL View
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.
Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…