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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Desktop Intelligence - Weighted Averages

Status
Not open for further replies.

lrowley

Technical User
Apr 19, 2012
1
GB
Hi there, new to the forum.

I have managed to setup a variable that gives me a weighted average of different objects and had added this to a cross-tab query, which works perfectly (tested using a sumproduct formula in Excel). However, when I run the report for a period of more than one month. the additional month name appears at the top but the weighted average is the same across the board. Is there a way to show the different averages for the different months.

Variable: =Sum(((<Advance Value>/(Sum(<Advance Value>) In <var_Concatenate>))*<var_Term>) In (<Contract Number> ,<var_Concatenate>)) In <var_Concatenate>

Many thanks in advance
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top