Max Date in table returns only values for the first row

[Anonymous]

Hello community,

as you always have good ideas for solving a Problem, here is as follows:

I have data with an article number, testing date, a delivery quantity and the testing result (amount of failures)

article number	testing date	delivery quantity	amount of failures
505010111	01.01.1990	5	1
505010111	01.02.1990	5	0
505010112	01.02.1990	150	0

Then I created a table, that Shows the latest 3 testing results per article.

Quality Quotient: 1 - (failures / delivery quantity)

but when I use the max(date) formula the table will only return the correct value for the first line...

1 -

sum(
{< TestingDate  = {"$(vPE1)"}
>}
AmountFailures)

/

sum(
{< TestingDate  = {"$(vPE1)"}
>}
AmountFailures) 

with  vPE1 = "=max(TestingDate,1)"

If I only select one article, the calculation suddenly works...

Thank you for your help,

Kevin

[Anonymous]

I will look into both Solutions today, as I am back in the Office.

Thank you so much for your help!

Kevin