rank with distinct

[TomBond77]

Hi experts

Why do I get a expression error with this expression?

(rank([Avg. Time%]) distinct [Vendor])

[ogster1974]

what are you doing with the vendor? counting?  Its not really clear what you are trying to achieve

if you are using the rank inside another expression it will need to be done with set analysis

[sidhiq91]

@TomBond77  Could you please post some sample data and also the expected output? That will help us to come with some solution for your issue.