Max Value in Group Table Calculation (Window Functions in Table Calcs)

Knowledge Drop

Last tested: Mar 29, 2021

This assumes you've setup the group_start_row and next_group_start_row table calculations from the Window Functions in Table Calculations Community Post

row_offset_till_group_start:

if(row()=${group_start_row},0,0-1*(${group_start_row}-row()))


offset_number:
${next_group_start_row}-row()+1

Grouped_list:
offset_list(${field},-${row_offset_till_group_start},${offset_number})

max_in_group:
max(${grouped_list})

This content is subject to limited support.                

Version history
Last update:
‎05-07-2021 09:48 AM
Updated by: