How do I create a variance column from two filtered columns?
In the attached image, we have two filtered columns, "Actual - 2019" and "Forecast April - 2019", I want to add a "Variance" column, which is the difference between the two columns. How do I reference the columns to build the formula to perform the subtraction?
Hi Kevin, the Incorta table that stores your actuals and the Incorta table that stores your forecast should have a common parent table. When doing variance, this table is almost always a Calendar table (time based). That way, you can group by Month on the parent table and show the actuals next to the forecast and also create a formula field for the difference between actuals and forecast. Does this make sense?