Hi Massimo,
Many thanks for the help.
Infact wanted to tell that this Value field is calculated from an expression like below:
=Count(DISTINCT{<[PO Line On-Time] = {'Y'},[Supplier Material Number] = {"=Rank(Count([PO Doc - Item]))<=5"}>}[PO Doc - Item])
/
count(DISTINCT{<[Supplier Material Number] = {"=Rank(Count([PO Doc - Item]))<=5"}>}[PO Doc - Item])
So, when I am applying Rank function here, it doesn't takes the Smallest 5, rather it takes some Random 5 in between.
Any issues in my expression?
If I store this expression in a variable and try to Rank it....Will that help?
