Tuesday, August 19, 2014

RMAX

This function takes a set of records as input and shows the maximum value based on records encountered so far.
Syntax: RMAX(expr)
Syntax description
expr is an expression of any datatype.
Steps: Go to Criterial – Select the Column – Right Click – Select Edit Formula – Click on Insert function – click on Running Aggregate folder and select RMAX

Example: RMAX("Sales"."Rp Revenue")

No comments:

Post a Comment