Calculating the Total Sales Amount for the Current Month

Article Number:040756

In the app that records the sales amount, sum up the sales amount for the current month and display the result as shown below. Screenshot: The total sales amount for the current month

Suppose that the form has the following fields:

  • "Date" field with the sales date entered
  • "Sales amount" field with the amount of sales for that day
  1. On an app's "View" screen, click the Create Graph icon. Screenshot: The "Create Graph" icon is outlined

  2. Click Others under Design a Graph Starting from Graph Type.

  3. Specify each item.

    • Chart Type
      Select Table.
    • Group by
      Select "--" (none selected).
    • Function
      Select Sum and "Sales Amount."
    • Conditions
      Select Date, = (equal to), and This Month. Screenshot: The settings under "Graph Options"
  4. Click Apply.
    The aggregate result is displayed.