Hi! I would like to link to one of the categories from another model, but I’m only able to select the total value when building my formula. Is there another way to approach this? In my instance, I would like to include DevOps salaries in my COGS, but right now, the formula pulls in total salaries.
Here’s a description of my use case: Loom | Free Screen & Video Recording Software | Loom
Hey @Marianna_Kerppola ! You just need to add the Department category to the “Financial Statements” model. Head to the bottom right of the model where it says Categories, click on the Department category, and then click Link to model.
After you do that, any variables that have that category will be broken down by Department, and then you can filter for just Engineering by hitting the category modifier button, and then clicking “Engineering” (see our docs here).
Hope that helps
Fantastic! Thanks so much for pointing out that detail! Hadn’t noticed the “Link to Model” option.