10 Day Count Down - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Kenneth DevorakKenneth Devorak 

10 Day Count Down

I'm trying to create a formula for a report that starts with the number 10.

Scheduled Start Date + 10 Days. Every day that goes by I want it to subtract 1 day.

Any help would be great.

Thank you,
Best Answer chosen by Kenneth Devorak
Kenneth DevorakKenneth Devorak
The only way to run the formula is to create a formula field. This formula can't be run on the report.

All Answers

Steve MolisSteve Molis
Can you elaborate and provide some context?  

How is this Formula going to be put to use? 
Kenneth DevorakKenneth Devorak
Schedule start date could be any date from today. Go forward 10 days and subtract 1 day every day. 

We have to hit a target within 10 of the scheduled start date. Then I can see how many days we have left to hit the goal.
Steve MolisSteve Molis
Can you post a screenshot of the Report, Settings, and Filters that you're using, the results you're getting, and a mock-up of what you want?  For questions related to Reports and Dashboards those are really helpful 
Steve MolisSteve Molis
I still don't understand how this Formula is being used.  Is the Report going to reference the Formula and use it as a Filter or something like that? 
 
Scheduled Start Date + 10
is simply going to return a Date value that is 10 Days after whatever is in the Scheduled Start Date Field 
 
Kenneth DevorakKenneth Devorak
No. Its just a visual. No filters
Kenneth DevorakKenneth Devorak
This formula does not subtract 1 day every day.
 
Steve MolisSteve Molis
I know that
Kenneth DevorakKenneth Devorak
Do you know how to do this formula?
Steve MolisSteve Molis
So it's basically just a Formula(Number) like this?
 
(Scheduled Start Date + 10) - TODAY()

 
Kenneth DevorakKenneth Devorak
It throws an error:
Incorrect parameter type for operator '-'. Expected Number, received Date
Steve MolisSteve Molis
Did you select Number as the Formula result type?
Steve MolisSteve Molis
Can you post the exact formula that you are using and a screenshot of the Formula Editor showing the error?
Kenneth DevorakKenneth Devorak
The only way to run the formula is to create a formula field. This formula can't be run on the report.
This was selected as the best answer
Steve MolisSteve Molis
I thought this was a Formula Field all along (not a Report Formula)