February 2017

Custom dynamic “date range filters” in Salesforce reports

**Introduction** This post is about overcoming one of the limitations of Salesforce report builder: Filtering data based on dynamic date ranges e.g. last 200 days or next 3 weeks and not just the following available options: **Note** # To appreciate... Continue Reading →


Complex Salesforce Reports: Compare ‘moving averages’ with ‘current month’ value

**Introduction** This one is another use of the almighty Custom summary formula (CSF) in Salesforce reports. Use them - they don't bite! **Note** To appreciate the solution, I hereby request all my readers to try to solve/create the report (described... Continue Reading →

Email scheduled reports only if not empty (and other advanced conditions) Part-2

The topic has 3 posts, of which this is called post 2 or part 2. 1. Part 1: This post covers sending email with a link to the report only if the total number of records are NOT zero i.e. not... Continue Reading →

Unlocking ‘Report and Dashboard’ sharing

The knowledge of reports and dashboard sharing is a must for all admins who want to show and enable the right reports for their users. Below you will find a table that I use as a guide to setup the sharing model... Continue Reading →

Rollup fields for lookup relationships

**Introduction**   One of the questions that is asked almost every 3rd Day (my random estimation) has a solution that lies in having roll-up fields for lookup relationships. There is an awesome app from Andrew Fawcett (at that you... Continue Reading →

Powered by

Up ↑