Need to Deterime Maximum Value of a Field Less One

[kc27]

Hi

Can someone tell me how to adapt the code below so that it returns a number that is the maximum value minus 1. For example if the maximum value is "35", I would want to display "34"

{table.field} = Maximum ({table.field}, {table.field})

Thanks in advance for your help on this.

 

[Charliy]

(maximum({table.data_field},{table.group_field}))-1

 

[kc27]

Thank you!