Good day Zoho Gurus,
I have this in an html filter:
<%for each x in VAR_Staff
{
Person = x.Short_Name;
HoursTotal_0_7 = Packaging_Process_Person_Workload[(Staff_Name == Person && (Due_Date <= (zoho.currentdate + '1W:0D:0H:0M:0S') && Due_Date >= zoho.currentdate))].sum(Estimated_Hours);
HoursTotal_7_14 = Packaging_Process_Person_Workload[(Staff_Name == Person && (Due_Date <= (zoho.currentdate + '2W:0D:0H:0M:0S') && Due_Date >= zoho.currentdate))].sum(Estimated_Hours);
HoursTotal_14_21 = Packaging_Process_Person_Workload[(Staff_Name == Person && (Due_Date <= (zoho.currentdate + '3W:0D:0H:0M:0S') && Due_Date >= zoho.currentdate))].sum(Estimated_Hours);
HoursTotal_21_plus = Packaging_Process_Person_Workload[Staff_Name == Person].sum(Estimated_Hours);%>
<tr class=zc-viewrow>
<td><%=Person%></td>
<td><%=HoursTotal_0_7%></td>
<td><%=HoursTotal_7_14%></td>
<td><%=HoursTotal_14_21%></td>
<td><%=HoursTotal_21_plus%></td></tr> <%}%>
How can I get values in my html tables of cero instead of "null" (of course, when the sum(Estimated_Hours) = 0) ?
Thanks !