Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Use of Variance formula (=Var)

Status
Not open for further replies.

BadBO

Technical User
Oct 2, 2008
10
GB
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.

 
I think you need a formula like:

[Measure]- Previous([Measure])

Steve Krandel
Intuit
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top