Wrong Total calculation of days

[francisvandergr]

I have the following formula in my chart.

today()-Vervaldatum

This formula calculates the days after invoicedate.Nowi want a total of all thos days from all invoices.

This is my new formula: sum(today()-Vervaldatum) The problem is that all days show are not good. Do i make a mistake in this formula ?

[#2]

Hi,

please try this

=networkdays(today()-Vervaldatum)

Put date format same. May this will help you.

Thanks & Regards,

Yogesh

[francisvandergr]

It was not the answer. I have solved it with option sum of rows instead of expression

[#4]

HI,

Are you looking this expression tabular form.

So try

Vervaldatum-today()

which r in number format.

If am not wrong.

else can you share your application.

Thanks & Regards,

Yogesh