3 Replies Latest reply on Feb 28, 2017 1:50 PM by Joe Oppelt

    Adding Difference Column to Multiple Year Comparison (Budget vs Actual)

    Justin Robichaud

      Hi,

       

      I have attached a packaged workbook with the table I am trying to modify. I would like to add a column after the "Budget" column for each year with the difference between the two columns preceding (ie Actual minus Budget). Also, once I do get these additional columns up, I'd like them to be coloured red/green if they are positive or negative. Seems like it should be simple enough, but I haven't been able to find a proper solution looking through the forums.

       

       

      Not sure if it necessarily complicates anything, but the measure I am using in the table is generated through a parameter.

       

      Any help on this would be much appreciated!

       

      Thanks,

      Justin