count at max date with status

[#1]

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.

[#2]

doesn't seem right. I used it in main function and again only 0 values.

but i tried this at the date column and i get the lasted dates where status<70 is right:

aggr({<status = {'<70'}>} nodistinct max(beleg_dat),ord_ipactype1)

strange thing there is I get the right latest date but not the sum of these rows

[#3]

let me check my data. cause this only happens in one row and only in this order I have the case that there are multiple record with status<70 and different dates. Atleast if have the right highest date of them. need to fix the sum calc now.