Round Page Number 1

[HezMac]

Hello

I'm trying to put the PageNumber function in a formula, and it's coming back "Page 3.00 of 4.00".

I've tried the Round function but doesn't seem to be working. Is there something else I should try?

Here's the function:

If {V_CRYSTAL_EL_RENEWAL_NOTICE.OPTOUT} = 'NO' THEN
    'Page ' & Round(PageNumber - 1,1) & ' of ' & Round(TotalPageCount - 1,1)
ELSE
    PageNofM

 

[lbass]

Try:

If {V_CRYSTAL_EL_RENEWAL_NOTICE.OPTOUT} = 'NO' THEN
'Page ' & totext(PageNumber - 1,0,"") & ' of ' & totext(TotalPageCount - 1,0,"")
ELSE
PageNofM

-LB

 

[HezMac]

Nice! Perfect!

Thanks, LBass!