Number of days between dates

[Anonymous]

I am working on an app, and there are customer complaints. If their is a complaint the date exists, if not the date is not in the application.

We want to calculate the record number of days between complaints and the current number of days without a complaint.

Could you help me figure out the formulas? looking to do KPIs.

Thank you

Ariana

[OmarBenSalem]

have this answered ur question? arianaford

[Anonymous]

It did not help me to make the KPI that has been requested. I feel as though it doesn't give a clear answer in a table form.

Thanks though for the help

[OmarBenSalem]

first of all, you could have thanked me for my time..........

second of all, I already provided with an expression u could use in your KPI:

max(all NumberOfDays) (Which I used in the coloring of the table...)

and an expression for number of days without complaints:

Today(1)- vMaxDate

you're welcome...........