Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have to write an expression for -on selection of a particular month i want count of material whose production qty is 0 for the selected month as well as for its previous month.
kindly help.
Regards
COUNT(Distinct {<Month = {'$(=Max(Month))'}>}material) + COUNT(Distinct {<Month = {'$(=Date(Max(Month)-1,'MMM'))'}>}material)
I also need to insert Production qty condition in expression