Welcome to Day 10 of our 12 Days of CRMas. In this blog series, we have been exploring the best and brightest of Microsoft Dynamics CRM 2015's new features. Today we'll take a look at Calculated Fields.
Yesterday, we helped Santa get a quick view of Tiny Tim's naughty/nice ratio with the use of Rollup fields. Today, we'll use the new Calculated Field feature to help Santa establish a dollar estimate for Tiny Tim's toy allocation.
Buddy the Elf is responsible for benchmarking the amount of gifts to make for each kid. From the previous lab, we established that a record is kept for each child for Naughty Things and Nice Things. Buddy has determined that Nice Things will result in a $10 credit and Naughty Things will be debited based on severity of Naughty-ness. The scale he established was 'Not so bad'=-$3 and 'Just awful'=-$10. When he is finished, he'll have a good idea about how much Elfen Magic to apply to each kid. We will be calculating in USD since 'Elfen Magic' is not a recognized currency in Microsoft Dynamics 2015.