Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
Could you post your sample app to check?
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.
Or try
Sum(Aggr(NoDistinct
(NetWorkDays(
RangeMax(Min(TOTAL {<Illustrator>} Date), Max({<Illustrator>} StartedDate)),
RangeMin(Max(TOTAL {<Illustrator>} Date), Max({<Illustrator>} EndDate))
)*8
), Illustrator))
PFA!
Thanks,AS
Sorry Jonathan,
Not working.
Thanks,
AS
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)
Sorry Manish,
It is working just for 2018 , but if I select 2017 or other Years , numbers are different.
Thanks,
AS
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))
Thanks Manish!
Regards,
AS