In a joined report, I've created a formula field to pull numbers from three separate columns (Sales, Backlog, Forecast) but if there's a blank row in one of the columns (Backlog in this case is sometimes populated and sometimes not), the formula does not run. How do you make it so for every blank in Backlog it is changed to 0 before the formula runs?
The formula is (Sales+Backlog) / (Forecast)
Issue: When Backlog is blank then formula does not produce (Sales+0) / (Forecast)
8 answers
Hey James,
Well. Try this:
(Sales + BLANKVALUE(Backlog,0)) / Forecast
Best,
Deepak
