Skip to Content
0
Former Member
Feb 19, 2009 at 03:59 AM

TotalPages() Enquiry

37 Views

Hi,

I am trying to create Fields in the Invoice PLD to link to the Fields to formulas such as "CurrentPage()" and "TotalPages()"

e.g

Field_1 (Formula Type)

Content: CurrentPage()

Field_2 (Formula Type)

Content: TotalPages()

I am trying to create a formula where for example:

Field_3 (Formula Type)

Content: Amount(Field_1)==Amount(Field_2) or

Field_1==Field_2 ... etc

Note: Field_3 is used to hide contents within the RepetitiveAreaFooter where certain contents will only appear in the last page of the Invoice.

However, i found that the above does not work.

Coz, while CurrentPage() gives out a numeric value, the TotalPages() formula does not give a numeric value. and the forumla will give the wrong result.

Anyway of converting the value of Field_2 - TotalPages() into a numeric value?

Thanks lots!