To improve the modeling experience in Francis, we've introduced a range of new AVG and SUM functions. Each function comes in three variants: YTD, LY, and LAST, making modeling faster and more flexible than ever. The complete list of added functions is:

• avg()

• avg_ytd()

• avg_last_year()

• avg_last()

• sum()

• sum_ytd()

• sum_last_year()

• sum_last()

To learn more about each function and its intended use cases, visit our documentation.