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!