Previous Contributor

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

1 REPLY 1
Highlighted
Contributor

Re: Getting the maximum value

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