Formulas

💰 Shared expenses

• 2023 expenses - Per persons

round(prop("Amont") / prop("For how many people ?") * 100) / 100

• Totals - report

prop("Purchases total") - prop("Expenses")

🧹 Housework

• Next date

dateAdd(prop("Date"), if(prop("Frequency") == "Mensual", 30, if(prop("Frequency") == "Annual", 365, if(prop("Frequency") == "6 months", 183, if(prop("Frequency") == "Weekly", 7, 0)))), "days")

🎉 Events

• Status

prop("Date") < now()