{"id":"8a9bcd4c-653f-45bd-8e15-ec785fd8bf68","createdAt":"2024-06-12T22:00:00.000Z","updatedAt":"2024-06-18T08:30:51.403Z","isDeleted":false,"version":59,"date":"2024-06-12T22:00:00.000Z","published":true,"title":"Introducing AVG and SUM functions","notes":{"type":"doc","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"text":"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:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"text":"avg()","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"text":"avg_ytd()","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"text":"avg_last_year()","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"text":"avg_last()","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"text":"sum()","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"text":"sum_ytd()","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"text":"sum_last_year()","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"text":"sum_last()","type":"text"}]}]}]},{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"text":"To learn more about each function and its intended use cases, visit our ","type":"text"},{"text":"documentation","type":"text","marks":[{"type":"link","attrs":{"rel":"noopener noreferrer nofollow","href":"https://docs.francis.app/guides/documentation/modeling/functions","class":null,"target":"_blank"}}]},{"text":".","type":"text"}]}]},"archived":false,"imageUrl":"https://uploads.productlane.com/40431b87b3f81f67c8eed70dd1efa216.png","projectId":null,"changelogStatus":null,"workspaceId":"e7c97f92-84aa-4319-86f8-6c1043c22054","html":"

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.

Francis changelog

Introducing AVG and SUM functions