Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends
In attached application,I need to display count of projects delayed and completed on time in Benchmark column.
Ex: it should give count of negative values and positive values available in column when expanded.
For , NPD 122, Proj Name Capacity Expansion it should display '5 -0' as (5 count of -9 is available in data) under Benchmark column when collapsed til Project Name. As of now its showing -45.
Thanks & Regards
Chintan
Try this
=If(Dimensionality() = 2,
Sum(Aggr(If(Sum({<End={'Start'},Task_Group={'Benchmarking'}>}S_DayDiff1)> 0, 1, 0), NPR_WBS, Project_Name_WBS)) & ' - ' & Sum(Aggr(If(Sum({<End={'End'},Task_Group={'Benchmarking'}>}A_DayDiff2) > 0, 1, 0), NPR_WBS, Project_Name_WBS)),
Sum({<End={'End'},Task_Group={'Benchmarking'}>}A_DayDiff2) - Sum({<End={'Start'},Task_Group={'Benchmarking'}>}S_DayDiff1))
Display '5 -0' or do you just want to see 5?
Hi Sunny,
5-0 for this case , but if positive are 3 then 5-3 and so on.
And this is when the chart isn't expanded? What happens when the chart is expanded?
Try this
=Sum(Aggr(If(Sum({<End={'Start'},Task_Group={'Benchmarking'}>}S_DayDiff1)> 0, 1, 0), NPR_WBS, Project_Name_WBS)) & ' - ' & Sum(Aggr(If(Sum({<End={'End'},Task_Group={'Benchmarking'}>}A_DayDiff2) > 0, 1, 0), NPR_WBS, Project_Name_WBS))
Try this
=If(Dimensionality() = 2,
Sum(Aggr(If(Sum({<End={'Start'},Task_Group={'Benchmarking'}>}S_DayDiff1)> 0, 1, 0), NPR_WBS, Project_Name_WBS)) & ' - ' & Sum(Aggr(If(Sum({<End={'End'},Task_Group={'Benchmarking'}>}A_DayDiff2) > 0, 1, 0), NPR_WBS, Project_Name_WBS)),
Sum({<End={'End'},Task_Group={'Benchmarking'}>}A_DayDiff2) - Sum({<End={'Start'},Task_Group={'Benchmarking'}>}S_DayDiff1))
Perfect Bro...
Thank you so much...