Hello Everyone!

I am looking to have ZOHO CRM assign a lead cost based on what we are spending on our campaigns. This is my diliemma:

When entering a new lead into CRM, we are associating that lead with a Campaign (in a field). We added a custom field "Lead Cost" which I would like to have an average cost assigned in there. This would be based on what was spent for the campaign during a specific time period. For example, if we had a home show named "Test" on August 1, 2020 and spent $2,000, I would like the "Lead Cost" field to be updated with an average spend. If we received 20 leads from this campaign, then the average per lead would be $100. The $100 would show up in the "Lead Cost" field. I can then set up a dashboard and reports to easily track our average spend (and I know it would be a variable number as more leads come in which is fine). 

Is this possible? Thank you!