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!
5 respostas
you can add it like this:
IF([2016 Inbound New Business Leads].RowCount < 1, 0,
<insert your existing Summary formula here
)
