Create field in script editor according to set analysis formula

[JoannaM]

Hi all

I have created the following formula in set analysis:

sum(
aggr(
Sum(total [BU production days])
/
[production days per year]
*
aggr([production days per month],%date)
,%date)
)

I am breaking down a yearly budget to production days.  I tried everything and the formula above is the only one working for me and giving me back the numbers I need.

How can I translate this to the script editor?

Thanks for the input.

BR, Joanna

Maybe @rwunderlich, you have an idea? Last time I also had a similiar chanllenge and because of your input I could solve my problem.

[Anil_Babu_Samineni · Accepted solution]

May be like this?

Table1:
Load %date, Sum([BU production days])/Sum([production days per year]) as TotalSum Resident Table Group By %date;
Left Join (Table1)
Load %date, Sum(TotalSum) as Sum_New Resident Table Group By %date;