Hi,
I have a problem with creating a line chart.
Formula right table to get the cumulative quantity (per article, per day) and if an article is below 0 then value 0.
IF(sum(AGGR(rangesum(ABOVE(SUM(quantity) + SUM({1} 0),0,ROWNO())),ItemCode, (days, (numeric, Ascending))))<0,0,sum(AGGR(rangesum(ABOVE(SUM(quantity) + SUM({1} 0),0,ROWNO())),ItemCode, (days, (numeric, Ascending)))))
next thing i want to do is get the total quanity of al items per day but then i get the error: The Chart is not Displayed Because it Contains Only Undefined Values
Could someone help me?
Thanks