I am trying to use the ToDec to convert a string into a field which is a currency and says it is decimal.
The error says that the formula is a floating field and then suggests to use the ToDec to convert.

Please explain why this is not working.

Here is the actual code attempted:

CASE [Contract Package]
WHEN 'Spotlght Affair' THEN ToDec(2450)
WHEN 'Ul;timate Experience' THEN ToDec(3650)
WHEN 'Dance Extravaganza' THEN ToDec(4950)
WHEN 'Club Spotlght' THEN ToDec(6950)
WHEN 'Elegance' THEN ToDec(1550)
WHEN 'Dedication'THEN ToDec(1750)
END

also tried with ' inside to make char string: but says syntax error
WHEN 'Spotlght Affair' THEN ToDec( '2450' )

Richard,
try the following formula :

CASE [Contract Package] 




Edited 1 time(s). Last edit at 04/14/2007 10:00AM by Admin.