I have a field called Total Contract Value.
It is a currency field that is usually in the millions.
My client has requested that I create another currency field that rounds up the number in the Total Contract Value field to the nearest million. I'm not sure how I would do that with a formula field.
Any help would be wonderful.
6 个回答
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
Don't worry, we were all beginners at some point.
Try this:
(Total_Contract_Value__c+(
IF(MOD(Total_Contract_Value__c,100000)<50000, 0, 100000)-
MOD(Total_Contract_Value__c,100000)))/1000000
I have to leave now, but if it still doesn't work, add example and I can have a look at it tomorrow, or others can also help you
