FRank question in combination with FHist argument

Hi

I’m trying to select the top decile for 1-year employee growth. I can retrieve the employee count using the FHist formula: FHist(“Empl”,52)

Unfortunately if I embed this into an FRank formula

FRank(“Empl/FHist(“Empl”,53)”,#sector,#desc) >90

, I get the error “ERROR: Invalid criteria in Rule 6. Error near ‘FHist’: FHist - Missing operands”

Does anyone understand why this is not possible to do ?

Thanks,

Oliver

It’s due to the nested quotes. You can do it by creating a custom formula. Will look like this

FRank(“Empl/$empl1Y”,#sector,#desc) >90

With a custom formula like this

$empl=FHist(“Empl”,53)

Ok, thanks ! That was helpful.