total of paid invoices only

[thezed]

Hi,

I am quite new to the script writing, I struggle trying to do the following:

In a table, Invoices, I have for each record a field with the Payment date (Pay_Date). On a different layout, I am trying to get the total value of the unpaid invoices only.

I guess I have to create a script that get this value into a variable that I can then use in my new layout. Has anyone an idea of how I can do that?

Thanks,

Z.

[mr_vodka]

I think we need more info here such as what you mean by "On a different layout". What TO this layouts based off of?

For example, you can create a stored calculation of IsEmpty (Pay_Date) to flag which ones have not been paid, let's call it Status, if you are using the Pay_Date field as your paid indicator.

You can create a relationship keyed from a constant calculation field that just returns 1 to this new Status field. You can then either create another calc to sum it up using the Sum() function, or create a summary field in your Payment table that totals the amount and put the field on the parent layout.