The following formula is working but it seems rather ugly. Is there a better way to get calculated integers to show up in a decimal field?
SET Multiplier = (convert(decimal (18, 4),Accounts) - convert(decimal (18, 4),Contacts)) / convert(decimal (18, 4),Accounts)
Data types used:
Multiplier is a decimal
Accounts and Contacts are integers.
SET Multiplier = (convert(decimal (18, 4),Accounts) - convert(decimal (18, 4),Contacts)) / convert(decimal (18, 4),Accounts)
Data types used:
Multiplier is a decimal
Accounts and Contacts are integers.