Is there any way to calculate with ## ?

[nangko]

I have a report of several invoices wich restarts the page numbering after each invoice.

So one invoice can have more then one pages (depends on the amount of invoice_items).

I want the totals-data of an invoice always beeing displayed in the footer of the last page of the invoice.

Therefor I wan't to hide (using conditional formatting) the totals-data when ## != invoice::total_pages.

But I can't use the symbol ## in a calculation.

Does anyone knows how to get the ## data in a calculation?

Maybe there is custom function like get(Printed_Pagenumber)?

[IdealData]

Can you re-think the report.

1. Make each "invoice" report a separate report

2. Use a TITLE footer to display the totals

3. Script the report(s) with a loop

[comment]

This cannot be done using page numbering, because Filemaker calculates them on-the-fly when rendering the printed report, and there is no cross-reference between pages and records.

You could try testing for the last record in an invoice, e.g.

InvoiceID ≠ GetNthRecord ( InvoiceID ; Get (RecordNumber) + 1 )

See also:

http://www.fmforums.com/forum/showpost.php?post/252312/

Use a TITLE footer to display the totals

A Title footer appears at the bottom of the FIRST page - not the last one.