Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody;
I am using in one chart this expression:
Sum({1<Year={$(=only(Year))},MonthYear={"<=$(=max(MonthYear))"},Date={"<=$(=max(Date))"}>} Tons)
The expression works well when I select one date.
The problem is when I filter by the article A or B. One works OK but if i select the other article, all the selections dissapears and the chart is empty.
I think the problem with the date selected is becuase only one article A or B was manufacturing in the plant that day.
Is there one possibility to maintain with the date selected the article A or B or both?
Included if it is not manufactured in that day one of the two articles.
Thanks in advance.
Hi, probably your problem is with Only(Year), it this has two differnt values it will return null, try with Max(Year).
also you can set the expression in a simple table without column label, this way the label will be the expression with the $-expansion values expanded, and you can copy this label and set in another epxression to make some tests, removing or modifying the expression to find wich part is causing the issue.