OK so we're using Qbase for sales, so we track customers w/ "opportunities". Each customer can have multiple opportunities. For the purposes of production, we use a job number that, for now, we man...
Summary field totaling all opportunities for the year of 2018.. And field 2 that gets the value from the summary field and doesn't allow it to change. Then use field 2 in the formula?