Formula of Aggregated values from Different Tables
Hi,
Lets say i have these 2 tables, Revenue and Expenses. I have created an aggregated formula to sum the Total Revenue which is attached to table Revenue, and Total Expenses which is attached to table Expenses
Now i want to create a KPI Widget on my Dashboard that would show the outcome of Total Expenses divided by Total Expenses.
Please help to explain how should i go about doing this. Thank you