formula to calculate the revenue amount per location on the total revenue amount

AI generated answer (using internal Slack threads):

To calculate the revenue amount per location on the total revenue amount, you can use a formula similar to the one used for calculating the percentage of total. You can create a formula numeric field in your saved search. The formula would be something like this:

SUM({revenue_field_per_location}) / SUM({total_revenue_field})

Replace

{revenue_field_per_location}

with the actual field name that represents the revenue for each location, and

{total_revenue_field}

with the field name that represents the total revenue. This formula will calculate the proportion of the revenue for each location to the total revenue. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******