Issue with Expression

[Anonymous]

@stigchel‌

stalwar1

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

[sunny_talwar]

Display '5 -0' or do you just want to see 5?

[Anonymous]

Hi Sunny,

5-0  for this case  , but  if positive are 3 then 5-3 and so on.

[sunny_talwar]

And this is when the chart isn't expanded? What happens when the chart is expanded?

[sunny_talwar]

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))

[hamzabob1]

Dear Sunny,

thanks for your rpl but this is not what we want.

we want  count of positive and negative numbar when the chart is collaps and -9 when the chart is expand.

Plz once check project status sheet so u'll get what we want.

johnw‌

stalwar1 Thanks again.

[hamzabob1]

swuehl‌

jontydkpi‌

Please help...

Thanks

[sunny_talwar · Accepted solution]

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))

[hamzabob1]

Perfect Bro...

Thank you so much...