Rank Functiom

Hi @jhasa

You have run into a technical issue. The nested Aggregation error needs a little bit of deep dive.

Please review the article below to understand where your calculation may be breaking.

What @ErikG is saying is right. First try the rank on a simple case with one field so you can resolve the Nesting error. Once you have resolve the issue it is easy to extend it to bring all your calcuations in since they will all be similar in nature.

Regatrds
Giri