Forum Discussion
Date diff and Avg
Dear Sir i have one table as shown: i want to calculate avearge of delay in days here some condition:, final date= if(actual date=blank,plan date,actual date) delay= final date - for...
any way to do without creating calculated column ??
HI Anonymous,
You can add a variable with summarize function to summary table records and add the custom field with calculated expression, then you can use the iterator function to apply the second aggregations.
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng