Solved: How create a incremental sum based on date - Page 2

DaGi07 · 06-24-2022 02:22 AM

Hello guys,

i'm trying to create a incremental sum divided for different number for each row that are originate by the difference between two date in two different tables--> BUDGET_ODOO[Fine_progetto] and BUDGET_VS_CONS[Periodo]

I try to explain you better with these screen that show the structure of table BUDGET_VS_CONS

How can i convert this spreadsheet formula in a appsheet expression?

second question:

"remaining months at the end of the project" should be the difference between filed BUDGET_ODOO[Fine_progetto] and BUDGET_VS_CONS[Periodo] of each row (in order to decrease the result number as the [Periodo] increases

I tried with this expression but it doesn't works because [Fine_progetto] is in another table

((((YEAR([Fine_progetto])
- YEAR([Periodo])
)* 12)

+ MONTH([Fine_progetto]))
- MONTH([Periodo])))

I hope you will help me! tks

dbaum

Just like in the expression I drafted for you, if you have an expression in Table 1 that needs to reference a column in Table 2 and you've established references between the tables, you can use the "dot notation" convention of citing the column from Table 1 that serves as the link to Table 2 followed by "." followed by the column from Table 2. So, wherever you need to use [Fine_progetto] from the BUDGET_VS_CONS table, try instead [Progetto].[Fine_progetto].

View solution in original post