Skip to main content
Topics#Reports & DashboardsPergunta de Alissa Kim
Alissa Kim perguntou em #Reports & Dashboards
3 de dez. de 2018, 20:40

How to get the summary formula column on report working

We have 2 fields SLA (Number) and AGE (formula number). Our client is looking for a column that can point out if the Age is 10 days or more over the SLA. I thought this would be possible through the formula column, but can't seem to figure it out.

 

I tried the following:

 

IF(AGE > SLA + 10,1,0)

 

IF(AGE - SLA > 10,1,0)

 

Any ideas?
3 respostas
  1. Alissa Kim (Salesforce)
    4 de dez. de 2018, 15:50
    Thanks Sunil - Screenshot here.

     

    The forumula seems to take? But doesn't look like the If True = 1, If Fallse = 0 is working. Example is the first row. Age is greater than SLA + 10. Any ideas why it wouldn't be showing as 1 in my summary formula column?

     

     Thanks Sunil - Screenshot here. The forumula seems to take? But doesn't look like the If True = 1, If Fallse = 0 is working. Example is the first row. Age is greater than SLA + 10.
Escrever uma resposta...
0/9000