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!
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.
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |