On 2009 Jan 2, at 8:32, Ron wrote:
Many thanks for your reply.
I forgot to mention that my Value list field is a Year plus a fund-
raising campaign, thus I can’t define it as numeric, thus a
negative has no effect.
Maybe, maybe not.
Let's say you have 3 fund-raising campaigns:
Annual Campaign
Year-End Campaign
Guest Artist Campaign
You can calculate a negative numeric version of the year/campaign
combination like this:
NegYearCamp =
-1 * ( Year +
Case (
Campaign = "Annual", 0.1;
Campaign = "Year-End", 0.2;
Campaign = "Guest Artist", 0.3;
0
)
)
