22 Replies Latest reply: Jul 10, 2017 8:11 AM by Eric Hannert RSS

    count at max date with status

    Eric Hannert

      Hi comm,

       

      I want to calculate the amount of artikel with a status under 70 so the formular is like this atm.

      count(if(status<70,art_nr))

       

      But I have different dates of the date so for example we have

      3 articels with status under 70 at the 06.07.2017

      and 1 articel with status under 70 but at the 7.7.2017

       

      So I only want to count the 1 articel from the highest date which is the 7.7.2017.

      Hope someone can help me, I tried different formulars but seem to miss something.