Discussion Board for collaboration related to QlikView App Development.
I have several task in database.
All of them have a begging and end date.
task_begin: 12/03/2012 14:30
task_end: 21/03/2012 18:30
task_duration: NetWorkDays(task_begin, task_end)
I want to calculate the average task duration in days.
But due to data quality, I have to remove the values where (duration < 0)
How can I calculate the average without the (duration < 0)?
EX: if(duration > 0;day(avg(Duracao_dias_uteis)))
Avg(if(duration > 0, Duracao_dias_uteis))
View solution in original post