Knowledge Drop

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


Userlevel 3

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.                

 

 


0 replies

Be the first to reply!

Reply