I wanted to create summary report where I can collect the sum of the values, identify the highest and lowest value, or the most redundant value within the recordset. Browsing through the sub-form upon clicking "Add Agreggate Formula" in the left panel of the report tab (see image), i found different options from the Click to Insert Functions dropdown.

However, after writing the formula using the Statistical Formula Mode and clicking the OK button to save it, an error occurs:

My Formula: mode("Hour")

Sorry, cannot create a Aggregate Formula. You need to have an Aggregate function used in the formula.  For other types of formula, use "Custom Formula" option.

The Aggregate Formula Sum, Count and other formulas are accepted and does not generate any errors. The other formula in the dropdown aren't working as well. I don't think I was doing it wrong though. I assumed it is written exactly the same as the Crystal Report Formula wherein you drag the function and add fields on it.

Any ideas on this? Any topic you could link here?

My thought on this is that in the left panel (see above image), there are links for the other formulas, but because the height of the form is large, it overlapped within the page. As you can see in the image, the bottom border seems to be missing. Zooming in and out the page doesn't help. I cannot scroll to see what lies below.

Help will be very much appreciated.