I’m working on a simple P&L statement and I’ve run into a problem I can’t figure out. I have 2 fact tables (actuals, budgets) that do not have a direct relationship to each other, but each is connect to several ‘filter’ tables. The problem is my variance calculation - I want to show ‘good’ variances as positive number and ‘bad’ variances as negative. Currently, I’m subtracting Actual-Budget for all categories and what I need is to subtract Budget-Actual for all the various expense categories. I’m not sure if I should be looking at an IF, SWITCH or CASE statement and I can’t figure out how I can change a calculation on the fly based on the value of single column in a filter table. Thanks in advance for any thoughts or advice.