Advanced Functions

HELLO Salesforce Thinkers, In our previous blog we learned about Summary Functions in Salesforce In this blog we are going to learn about “Advanced Functions”. We have the following Advanced Functions  in Salesforce. CURRENCYRATE: Returns the conversion rate to the corporate currency for the given currency ISO code. If the currency is invalid, returns 1.0. Syntax: CURRENCYRATE(currency_ISO_code) Replace currency_ISO_code with a …

Continue reading Advanced Functions

Summary Functions in Salesforce

HELLO Salesforce Thinkers, In our previous blog we learned about Text Formula Operators and Functions in Salesforce In this blog we are going to learn about “Summary Functions in Salesforce”. Summary functions let us use grouping values in custom summary formulas for summary, matrix, and joined reports. There are two summary functions: PARENTGROUPVAL and PREVGROUPVAL 1. PARENTGROUPVAL : …

Continue reading Summary Functions in Salesforce

Text Formula Operators and Functions in Salesforce

HELLO Salesforce Thinkers, In our previous blog we learned about Math Formula Operators and Functions in Salesforce In this blog we are going to learn about “Text Formula Operators and Functions in Salesforce”. Formulas that use the Text return type can concatenate Text values, convert numbers and dates to text, or display text conditionally. Text Operators: & (Concatenate) : …

Continue reading Text Formula Operators and Functions in Salesforce

Math Formula Operators and Functions in Salesforce

HELLO Salesforce Thinkers, In our previous blog we learned about Logical Formula Functions in Salesforce, In this blog we are going to learn about “Math Formula Operators and Functions in Salesforce”. Math Formula Operators: We have the following Math Operators in Salesforce. + (Add) : Calculates the sum of two values. value1 + value2 Replace each value with merge fields, expressions, …

Continue reading Math Formula Operators and Functions in Salesforce

Logical Formula Functions in Salesforce

HELLO Salesforce Thinkers, In our previous blog we learned about Date and Time Formula Functions in Salesforce, In this blog we are going to learn about “Logical Formula Functions in Salesforce”. Logical Formula Functions: We have the following Logical Functions in Salesforce. 1. AND : Returns a TRUE response if all values are true, returns a FALSE response if …

Continue reading Logical Formula Functions in Salesforce

Date and Time Formula Functions in Salesforce

HELLO Salesforce Thinkers, In our previous blog we learned about Formula Fields in Salesforce In this blog we are going to learn about “Date and Time Formula Functions in Salesforce”. We can include formula functions in formula fields, validation rules, approval processes, and workflow rules. Date and Time Functions :- We have the following Date and Time Functions …

Continue reading Date and Time Formula Functions in Salesforce

Formula Fields in Salesforce

HELLO Salesforce Thinkers, In our previous blog we learned about Roll-Up Summary Fields In Salesforce In this blog we are going to learn about “Formula Fields in Salesforce”. Formula in Salesforce are used to calculate custom fields, validation rules, Flow logic etc. Formula field are read-only fields that automatically calculate a value based on other fields or a formula. Any …

Continue reading Formula Fields in Salesforce

Roll-Up Summary Fields In Salesforce

HELLO Salesforce Thinkers, In our previous blog we learned about Search Layouts in Salesforce, In this blog we are going to learn about “Roll-Up Summary Fields In Salesforce”. A roll-up summary field calculates values from related records. Roll-up summary field can only be created on the master object in a Master detail relationship. We can create a roll-up summary …

Continue reading Roll-Up Summary Fields In Salesforce