LoginSignup
0
0

ROW-Level Formulaを使う

Last updated at Posted at 2022-10-05

大体は数式フィールドを追加してもできるのですが、なるベくレポートだけでやってみたいと思います。

image.png

選択リストは数値でないので変換する必要がありますが、ROW-Level Formulaで可能です。

image.png

IF(ISBLANK(TEXT(Case.Work_Duration__c)), 0 ,VALUE(TEXT(Case.Work_Duration__c )))

Create a Row-Level Formula Column that compares opportunity owners to account owners.
Use that Row-Level Formula Column as a filter condition.

image.png

事例

If you create a Row-Level Formula Column like the following, it will be 1 if there is a date.
Therefore, you can count the number of items by summing this column.

IF(ISBLANK(Account.SLAExpirationDate__c),0,1)

image.png

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0