Storing historical data for potential probability

Storing historical data for potential probability

Hi all,

Currently we are using Zoho DB as the main source of data for the reports. I would like to know if we can have the following data store in Zoho reporting database:

- max probability that was ever reached for potentials (since the potential record was created)?

Basically, we would like to measure how many potentials reached final stages of negotiation (where probability for winning was very high), but were not won for some reason.

Do you have some ideas/formulas for that?

Regards
Vera