Aggr Help???

[amit_saini]

Hi Folks,

I'm having below straight table , total here is "768"

Dim : Illustrator

Exp:

=(NetWorkDays(RangeMax(Min(TOTAL {<Illustrator>} Date), Max({<Illustrator>} StartedDate)), RangeMin(Max(TOTAL {<Illustrator>}Date), Max({<Illustrator>}EndDate)))*8)

I want to use this total '768"in input box for some further calculation ,but not getting the exact numbers by using aggr function.

I'm trying something like below , but getting O/p as 192 , it should be "768".

=sum(Aggr((NetWorkDays(RangeMax(Min(TOTAL {<Illustrator>} Date), Max({<Illustrator>} StartedDate)), RangeMin(Max(TOTAL {<Illustrator>}Date), Max({<Illustrator>}EndDate)))*8),Illustrator))

Please help!

Regards,

AS

[tresesco]

Could you post your sample app to check?

[jonathandienst]

Your syntax is OK. It looks like a problem with the data model with Illustrator not being correctly associated with the Date  fields. Then 192 could be the correct result and 768 is just a table artifact created by summing the rows.

A sample app would certainly help.

[jonathandienst]

Or try

Sum(Aggr(NoDistinct

     (NetWorkDays(

     RangeMax(Min(TOTAL {<Illustrator>} Date), Max({<Illustrator>} StartedDate)),

     RangeMin(Max(TOTAL {<Illustrator>} Date), Max({<Illustrator>} EndDate))

     )*8

), Illustrator))

[amit_saini]

PFA!

Thanks,AS

[amit_saini]

Sorry Jonathan,

Not working.

Thanks,

AS

[MK_QSL]

May be try this

=((NetWorkDays(

RangeMax(Min(TOTAL {<Illustrator>}Date),Max({<Illustrator>}StartedDate)),

RangeMin(Max(TOTAL {<Illustrator>}Date),Max({<Illustrator>}EndDate)))*8)

-vHolidays

)*COUNT({<Illustrator>}DISTINCT TOTAL Illustrator)

[amit_saini]

Sorry Manish,

It is working just for 2018 , but if I select 2017 or other Years , numbers are different.

Thanks,

AS

[MK_QSL · Accepted solution]

Try this

=SUM({<Illustrator = P(Illustrator)>}Aggr(((NetWorkDays(

RangeMax(Min(TOTAL {<Illustrator>}Date),Max({<Illustrator>}StartedDate)),

RangeMin(Max(TOTAL {<Illustrator>}Date),Max({<Illustrator>}EndDate)))*8)

-vHolidays

),Illustrator))

[amit_saini]

Thanks Manish!

Regards,

AS