hey guys - I’ve got a gross profit margin variable (gross profit / revenue), which per month shows the right value… but in a table that just shows yearly, how do I get it to compute the right thing? the time aggregate function “sum” isn’t right, but neither is “average” ?
Hey Jelte, this is a perfect use-case for the formula time aggregation
It takes the variable’s formula to calculate the aggregation value, so in this case it would be the total gross profit divided by the total revenue of that year. To change the aggregation function, just right-click on the variable and select “Aggregation Function” → “Time Aggregation” → “Formula” in the context menu: