Forecast report using a formula column

I am trying to use a formula which looks at the total deal value and uses an associated % to formulate the estimated deal value based on the stage the deal is at. However in the dashboard when I chose to have the months from the expected close date along the x-axis and the formula column ‘expected deal value’ on the y it is not showing any data does anyone know how to resolve this?

Hey Lily,

Sorry you’re running into some issues here.

Would you be able to share a screenshot of what you’re seeing on your end? If possible, a screenshot of your board with the specific columns and the error in the dashboard, would be great, just so I can take a closer look :pray:




These are the settings i have for the chart and what is currently showing

Thank you for sharing lily… hmm this looks a little strange…

Would you be able to share a screenshot of the columns in your board? From what I can see this isn’t a mirror column, so I’d like to take a look at the columns to rule out any other issues. Thanks for your help :pray:

I have had to make them quite small as there is personal data on these boards: but these are the relevant columns