Formula for Revenue
Hello. I have a table that lists daily sales counts. I've created a summary report that aggregates this information by month but now I'm trying to add in a Revenue field where it takes in the total ...
Forum Discussion
In order to multiply a value, by an aggregated list, you will need to actually aggregate the data.
By this I mean, you have to summarize the data to a "Months" table, rather then just a report, grouped by month.
Once you have all the data summarized to the respective months, then you can use a formula for tiers.
There are several examples on this forum of how to set up a 'months' table, but let us know if you get stuck.
By this I mean, you have to summarize the data to a "Months" table, rather then just a report, grouped by month.
Once you have all the data summarized to the respective months, then you can use a formula for tiers.
There are several examples on this forum of how to set up a 'months' table, but let us know if you get stuck.