Loading

How To Show Sales of Today, This Month, Last Month in One Table

Date de publication: Apr 13, 2024
Tâche

How to show last month's sales, this month sales, today sales in one table.

Étapes
1. Create a Calculation field of Today's sales
IF [Order Date]=TODAY() THEN [Sales] END

2. Create a Calculation field of This month's sales
IF DATETRUNC('month',[Order Date])=DATETRUNC('month',TODAY())
AND DAY([Order Date])<=DAY(TODAY())
THEN [Sales] END

3. Create a Calculation field of Last month's sales
IF DATETRUNC('month',[Order Date])=DATETRUNC('month',DATEADD('month',-1,TODAY()))
THEN [Sales] END
Numéro d’article de la base de connaissances

001456957

Pièces jointes

Multiple Sales_v2019.4.twbx

1237 KB

 
Chargement
Salesforce Help | Article