Excel CORREL function in Apex Salesforce

By | August 14, 2017

Today we will see salesforce apex equivalent code for Excel CORREL function. Excel CORREL function in Apex Salesforce can be used if we need to perform same calculation on salesforce data as excel CORREL  function. Syntax of CORREL function is as follows in Excel CORREL(array1, array2) WHERE array1 and array2 both are Required. We must ensure that array1 and array2… Read More »

Excel LINEST function in Apex Salesforce

By | July 7, 2017

As a developer we sometime need to implement excel function in code for meeting client’s requirement. Here I will share code for Excel LINEST function in apex. You can check LINEST function/method of excel here. See below code method, you can use it in your apex class.

It will save your time if you… Read More »

Getting length of integer part and fractional part in apex of a number type field salesforce

By | June 29, 2017

Sometimes we need to play with field (custom field or standard) properties in apex. If we need to find the integer part length in a “Number” type field, then there is no direct method in Describe Field Result (DescibeFieldResult) class. But we can find it using some other methods of DescribeFieldResult class. Lets suppose we… Read More »

Overlapping pseudo code

By | June 11, 2017

As a developer, we sometimes need to write code for checking overlapping. We check overlapping for two objects having one start and end point (Overlapping between two appointments, overlapping between two courses, programs etc). For example lets take a Course as object, So Course has a Start Date and End Date. Course (StartDate, EndDate). Now… Read More »

Datetime on Visualforce Page

By | February 19, 2017

Whenever we are working with datetime on visualforce page, we may face some issue either with its formatting or its value not coming correctly. So basically the formatting of date depends on the locale of the user, and second thing which is its value depends on the timezone. In the salesforce database each datetime value is… Read More »