Operate with values calculated by group agrgate view option

[muketaz]

Hi everyone, Im making a sales managment app and been working to calculate a monthly profit estimation.

I calculate the profit of each sale in a row, so then I can divide monthly sales profit with virtual column:

[Ventas del mes] = EOMONTH([Fecha pedido], 0)

[Fecha pedido] is the sale date.

So then, in view options:

[Importe total] is the profit of each sale. So I Get:

This calculate the motnhly profit of sales.

Then I calculate all the expenses in the same way, and I get:

PROBLEM: I want to substract the monthly value of expenses to the monthly value of profit sales, and cant figure out with this method.

Is there a way to do it like this? Or I should calculate it in other way. I really like this monthly view.

Thanks in advance!

[anonymous]

Using the Group Aggregate only allows you to SUM values that are in a column, so to show an aggregate of Profit - Expenses, you’ll need to calculate that separately. You could do this using a spreadsheet formula or with another table. But the aggregate SUM function is limited to basic addition of existing columns.