Under my Accounts Module we track Marketing ROI revenue attribution rates. Basically any new account brought in by Marketing gets 100% of revenue attributed to their revenue in their ROI calculation in Year 1 of that customer, and in year 2 they get 33% recognition, and in Year 3 they get 25% recognition. This recognition percentage we call the "Burn Rate" and it is linked to customers based on how many years they have been a customer. The Burn Rate is a formula driven field inside the Accounts Module, linked to specific Accounts.

Under the Deal Module, I would like the "Burn Rate" from the Accounts Module to show on the Deal. This cannot be done via the "Lookup" field because that will just return the name of the Account; and I don't want the Account name, what I want is the "Burn Rate" field based on the Account Name.

Anyone know how I can achieve this?

Thanks