Aggregaed measure in condition

[TzufRaifMia]

Hey all!

TL;DR:

In viya4, I am trying to work with aggregated measures inside condition but it failed, how can it be solved?

my mission is to convert SAS code into VA steps, such that no code will be needed.

I am trying to replace proc ranks (which calculates percentiles and creates a new column 'p') with 'percentile' function,

applying it twice (I am interested in percentile10 & 90).

then, I am trying to check "if column < percentile10 then 1 else 0", which can later be used just as 'p' column has been used.

I got an error as attached here.

any ideas?

Thanks!