Question
How to replace NULL or missing values with zeros.For example, every project should have three stages in the view, and if there is no [Amount] data for a stage, then the view should show zero.
ZN(SUM([Amount]))
ZN( IF [Date] >= [Date Parameter] THEN [Amount] END )
ZN(LOOKUP(SUM([Amount]),0))
ZN( IF [Stage] = [Stage (Stage Master List)] THEN [Amount] END )