Helper Functions

Helper functions are often used in conjunction with other functions (or queries), these functions make certain tasks easier.

LRFilterThe LRFilter function is useful to work around the maximum forumla length limit of Excel by allowing you to break a single formula into smaller pieces. The LRFilter function was originally created to address Liberty Reports formulas with complex filter arguments, but it can be used for any text argument in any Excel formula.
LRKeepThe LRKeep function keeps the values in a data entry column on the correct rows when the adjacent query is refreshed, while also enabling adjacent formulas to fill down.