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
