Use of Variance formula (=Var)

[BadBO]

I am trying to add a column to a table which shows the daily variance from the previous day.

My table looks something like this:

Measure
Date1 5
Date2 2
Date3 9
Date4 7

I would like to add another column showing the variance from the previous day like this:

Measure Variance
Date1 5 5
Date2 2 -3
Date3 9 7
Date4 7 -2

I tried creating a new measure using the following formula but I didn’t get the result I expected: =Var([Total Value of Trades])

Any help appreciated.

 

[skrandel]

I think you need a formula like:

[Measure]- Previous([Measure])

Steve Krandel
Intuit

 

[BadBO]

Many thanks indeed, that works perfectly. I didnt use the 'Variance' function in the end and just used the 'Previous' function which I wasn't previously aware of.