Forum Discussion

Jack_Machesky's avatar
Jack_Machesky
Cloud Apps
03-25-2024

Formula to display null values

I have a widget that I would like to replace all null values with values of "0". I am trying to use the following formula: "CASE WHEN ISNULL (PASTYEAR(SUM([Total TotalSales]))) THEN 0 ELSE (PASTYEAR(...