Loading

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

Дата публикации: Apr 13, 2024
Задача

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

Действия
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
Номер статьи базы знаний

001456957

Вложения

Multiple Sales_v2019.4.twbx

1237 KB

 
Загрузка
Salesforce Help | Article