function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
lakshmi.sf9lakshmi.sf9 

How to get auto number mod value using formula field

Hi,

 

Auto number value is  "aaa-1000"

Auto_Number__c is a autonumber field and I am trying get mod value of thsi field but value is not coming # Error ! displaying.How can i get mod value of auto number field

 

MOD( VALUE(Auto_Number__c),7)

 

Please give solution for the above problem

 

Thanks

Dhaval PanchalDhaval Panchal
Auto number is not a number, its a alpha-numeric field so you have to extract number part and then convert it in to numeric and they try MOD function.
Dhaval PanchalDhaval Panchal
Try this,

MOD( VALUE(SUBSTITUTE(Auto_Number__c, 'aaa', '') ),7)