Help on null due data set analysis

[#1]

Hello,

I'm trying to see the average time that each customer has for its non-payed bills.

I have two field is "payment date" and "due date" and I would like to average the bills that are not payed.

Payment date = DATARECEBIMENTO

Due date = DATAVENCIMENTO

So I did this:

avg({$-<DATARECEBIMENTO={"null"}>} (TODAY() - DATAVENCIMENTO))

but the result is the same as

avg(TODAY() - DATAVENCIMENTO)

So i assume that in both cases it is calculating for all the bills, the whole $.

Any help?

Thanks!

[#2]

Hi,

1) "null" is not a real null, it is a string whose value is null. So, pls. be careful about it.

2) Can you provide a sample qlikview application or some data?

Regards,

http://quickdevtips.blogspot.com

[Sokkorn]

Hi lucascli,

Maybe I got you wrong. But let try this set analysis

=AVG({$<DATARECEBIMENTO -={"null()"}>} (TODAY() - DATAVENCIMENTO))

Do let me know after you tested.

Regards,

Sokkorn