Skip to main content
Topics#Reports & DashboardsMichael Rodriguez 的问题
Michael Rodriguez (Jack Morton Worldwide) 提问于 #Reports & Dashboards
2017年7月7日 17:24

Summary of record count is showing as blank instead of zero, throwing off my formula field.

Hello,

 

I'm trying to calculate my YOY lead percentage by month using custom fields and formulas. As you can see from the screenshot I'm getting an error for the month of Feburary. The report formula is calling on the summary of record count and since Feb 2016 had no records its showing as blank instead of 0.

 

My main question is why is it showing as blank while the future months in 2017 are showing as zeros and thus, the correct percentage? 

 

Any suggestions as to how I can get this fixed? Thanks!

 

Summary of record count is showing as blank instead of zero, throwing off my formula field.
5 个回答
  1. Jeff May
    2017年7月7日 21:25

    you can add it like this:

     

     

    IF([2016 Inbound New Business Leads].RowCount < 1, 0,

     

    <insert your existing Summary formula here

     

    )
撰写回答...
0/9000