1 of 1 people found this helpful
Can I ask why you can't use ZN?
Only other thought is something like:
IF SUM([Defects Remediated])=0 THEN MAX(1)
ELSE SUM([Defects Identified])
Than you so Much Larsen. Its working.
Our dashboard will display data for currentmonth-1.
Monthly data will be available by 5th of every month. If we use ZN() then first day of the next month the report will show the value 0,but actual data will be available by 5th of every month. That is the reason we are not using ZN/IFNULL() functions.
I changed this thread to type="question" and marked Bryce's answer as Correct Answer.