You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

rank function in a form

Accepted answer
edited Feb 29, 2024 4:37PM in Financial Consolidation and Close 3 comments


The function Rank() is available in a data form, but returns #Error.

Content :

The Rank() formula allows to rank values and then sorts them ascending or descending.

This works smoothly in a Report, especially combined with conditional suppression. This way one can build a report that shows your e.g. top 10 entities for something.

A dashboard visualization needs a data form to list the values to be presented. In this form I'm showing the children of a choosen entity (user variable in my rows). As columns I'm retrieving a single period in a data column and the next column is a formula column with a

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!