Footer - Total Page Number Incorrect

[Bonediggler]

Experts -

I have a little workflow here that outputs a bunch of PDFs grouped by doctor's office - one report for each office, for a total of more than 150 individual reports.  It operates via several macros and everything works great - most of the time.  We are using the "<#pg> of <#pgs>" functionality in the footer and on some PDFs it seems that Alteryx is miscalculating the total number of pages.  For example, there are only 9 pages in the PDF but the footer will say "Page 1 of 10", "Page 7 of 10" and so on.

Any idea what might be causing this? 

[echuong1]

Can you use the page number option in the footer building block? This should automatically add it.

[Bonediggler]

Hmmm.  This method seems to get the number of pages wrong as well.

[Bonediggler · Accepted solution]

Looks like the solution is to reduce the "Header/Footer edge distance (points)" from 10 to 5 in the Render tool.  I guess Alteryx was reading the 5 additional points as another page....?

[lydia_yang]

I have the same problem and adjust the header/footer edge distance didn't help.