Skip to main content

Evaluate Each Record in Reports with Row-Level Formulas.

banner_1
You may have created the formula field on the object to get data in the report. But, now from Summer ‘19, we have row-level formulas in Salesforce.
Row-level formulas enable us to create custom formulas to display in the report within the Salesforce report builder. That means we can quickly use the various formula like – Days to close, No of days since record created, etc. in our opportunity/object report without creating new fields on the object. This is a very productive win for admins, they can easily play with the data right within the report builder and display what we need without any extra configuration.
This is a beta feature, so there is some limitation mentioned in the summer ’19 release note.
To use “Row-Level Formulas” you need to enable it in Setup under report and dashboard settings.
1
Go To | Report Tab| Open report | Click on the icon shown in the screenshot | Select Add Row-Level Formula (Beta)
3
Enter Column Name | Description | Choose Formula Output Type | Choose Decimal Point | Add formula | and click on Apply.
Formula:
CLOSE_DATE - DATEVALUE(CREATED_DATE)
4
Save and Run the report. Now you can see the formula column in your report. Is it super easy? ðŸ™‚  You can add different formula column in your report according to your business need.
5
🙂

Comments

Post a Comment

Popular posts from this blog

Salesforce UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record

Unable to lock row - Record currently unavailable errors Description When a record is being updated or created, we place a lock on that record to prevent another operation from updating the record at the same time and causing inconsistencies on the data. These locks normally last for a few seconds and when the lock is released, other operations can do whatever processing they are supposed to do on the record in question. However, a given transaction can only wait a maximum of 10 seconds for a lock to be released, otherwise it will time out. Resolution What and when records get locked depends on the operation you are performing and the main record you are working on. The  Force.com Record Locking Cheatsheet   provides detailed information on this and it's highly recommended that you familiarize yourself with its contents. Common Scenarios that prevent unlocking record a. Email-To-Case When an email is processed by email-to-case, triggers on the email message
Post a Comment
Read more

How to Build a Basic Salesforce REST API (With Test Class)

How to Build a Basic Salesforce REST API (With Test Class) and Test with POSTMAN Salesforce : Creating Anonymous Apex REST APIs with Force.com The Force.com REST API lets you integration with Force.com applications using standard HTTP methods. This API provides a way to expose the data you have within your Force.com application to external applications – both mobile and non-mobile. A few useful bits of information related to these REST APIs: This sample Code you how to implement a simple REST API to fetch Account in Apex class: @RestResource(urlMapping='/Account/*') global with sharing class MyRestResource { @HttpGet global static Account doGet() { RestRequest req = RestContext.request ; RestResponse res = RestContext.response ; String accountId = req.requestURI. substring ( req.requestURI. lastIndexOf ( '/' ) +1 ) ; Account result = [SELECT Id, Name, Phone, Website FROM Account WHERE Id = : account
Post a Comment
Read more

Salesforce Callout using Future Method

Hi All, Today's topic , Use of Future method in web services callout. Consider one scenario, Whenever ,We create one Account record or Edit a Account record using UI, Populate Billing city based on Billing Zipcode . Like Below image before save, After Press the save button,Billing city should auto populate. We want to populate Billing city based on Billing zipcode using below API endpoint. Postal PIN Code API Postal PIN Code API allows developers to get details of Post Office by searching Postal PIN Code or Post Office Branch Name of India. It has following format:         1. Get Post Office(s) details search by Postal PIN Code             http://postalpincode.in/api/pincode/{PINCODE}         2.Get Post Office(s) details search by Post Office branch name            http://postalpincode.in/api/postoffice/{POSTOFFICEBRANCHNAME} Postal PIN Code API returns the response in JSON format. "Status" field in response is set to SUCCESS or ERROR, "
1 comment
Read more