Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
i have attached a sample qvw.
It has a pivot table with some calculations by product number.
My last expression 'Resp Diff' is a time difference.
i need to display the average time of that 'Resp Diff' (as a summary level) in a text box.
Please someone help me with the expression
Slight better expression:
=Interval(Avg(Aggr(If(
RangeSum(time_effective, -Pick(Match(Category, 'Red', 'Blue'), clock_start, Actual_clock_start))> (first_unit_time-Actual_clock_start) and
time_effective_flag = 1,
RangeSum(time_effective, -Pick(Match(Category, 'Red', 'Blue'), clock_start, Actual_clock_start), -(first_unit_time-Actual_clock_start))), ProductNumber, Category, Type)))
May be this?
=Interval(Avg(Aggr(if(
if(Category='Red',time_effective-clock_start, if(Category='Blue',time_effective-Actual_clock_start))> (first_unit_time-Actual_clock_start) and
time_effective_flag=1,
if(Category='Red',time_effective-clock_start, if(Category='Blue',time_effective-Actual_clock_start))-(first_unit_time-Actual_clock_start)), ProductNumber, Category, Type)))
Slight better expression:
=Interval(Avg(Aggr(If(
RangeSum(time_effective, -Pick(Match(Category, 'Red', 'Blue'), clock_start, Actual_clock_start))> (first_unit_time-Actual_clock_start) and
time_effective_flag = 1,
RangeSum(time_effective, -Pick(Match(Category, 'Red', 'Blue'), clock_start, Actual_clock_start), -(first_unit_time-Actual_clock_start))), ProductNumber, Category, Type)))
Personally I'd just change the chart type of that table to Straight Table and set the Total Mode of the last expression to Average of Rows.
thank you so much sunny
No problem