Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Second try:
When i filter for one product the data is correct per day (following picture):
per month, per day
When there's no filter applied, then the whole budget is on one material group:
Output wanted:
Expression:
num(
aggr(rangesum(above(
Sum(total[BU production days])/
sum(total[production days]) *
sum({<year={$(=year(today()))},date={"<$(=makedate(year(Today()), month(Today()), day(Today())))"}>}[production days])
,0,rowno())),year,month,day)
,'#’##0', '.', '’')
What am I missing?
Solved with an expression by breaking down the material groups.
Would you be able to add an expression for daily budget (which would be non cumulative)? to see what are the values which are getting used for the accumulation here?
might be easier to help if you can share a sample
What kind of sample would help?
.qvf file if possible or some raw data with the output expected from it
Hi Sunny, I changed my question to make it better understandable.
Solved with an expression by breaking down the material groups.