1 Reply Latest reply on Apr 17, 2018 5:29 AM by Mavis Liu

    Variance - Add only 1 column

    Jill Rossi

      I have data that is divided by fiscal year, and I want to calculate the variance between the two years. I want variance in a third column, but everything I have tried results in 2 columns being added - 1 for each fiscal year. One column shows as blank, and the other will show the variance. How do I get around this? Sorry - data is confidential.

       

        • 1. Re: Variance - Add only 1 column
          Mavis Liu

          Hi Jill,

           

          You could create three measures:

          One to calculate the value for fiscal year 1, one to calculate for fiscal year 2, then the third to calculate the variance. Ultimately you get something like this:

           

           

          2018-04-17_13h26_21.png

           

          2018-04-17_13h28_58.png

           

          2018-04-17_13h29_09.png

           

          Alternatively, you could create two different sheets and then bring it together it in a dashboard:

          One sheet for the fiscal year and the values

          One sheet for just the variance column

           

          Thanks,

           

          Mavis