Average Invoice value problem

[Bridget Eley]

Hi Jason

Make calc_RoundTotal a conditional statement that only shows the round total
if the record is not a credit note.

Bridget Eley




in article [email]5960d170dfaa31f8818edaab569a544c@news.1usenet.com[/email], JJ at
[email]JJ@jj.com[/email] wrote on 22/7/03 5:25 PM:

> I have a calc field in my invoices file of:
> Average(Invoice::calc_RoundTotal)
>
> this gives me the avarage value of invoices for a particluar customer.
>
> The problem is it also takes into account credit notes when doing the
> calc.
>
> How can I eradicate credit notes from the calculation?
>
> Thanks in advance
>
>
> Jason
>
> --

[JJ]

I have a calc field in my invoices file of:
Average(Invoice::calc_RoundTotal)

this gives me the avarage value of invoices for a particluar customer.

The problem is it also takes into account credit notes when doing the
calc.

How can I eradicate credit notes from the calculation?

Thanks in advance


Jason

--

[Matt Revenaugh]

Create a second field of type calculation.

myField = If(Invoice::calc_roundTotal > 0, Invoice::calc_roundTotal , "")

Now average myField

Matt Revenaugh

------

On 7/22/03 12:25 AM, in article
[email]5960d170dfaa31f8818edaab569a544c@news.1usenet.com[/email], "JJ" <JJ@jj.com> wrote:

> I have a calc field in my invoices file of:
> Average(Invoice::calc_RoundTotal)
>
> this gives me the avarage value of invoices for a particluar customer.
>
> The problem is it also takes into account credit notes when doing the
> calc.
>
> How can I eradicate credit notes from the calculation?
>
> Thanks in advance
>
>
> Jason
>
> --