Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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;