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!

Register Log in
  • 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!

Problem referring to aggregates in query calculation

Status
Not open for further replies.
AndrewAfresh

AndrewAfresh

Programmer
Jan 30, 2012
2
GB
Please can someone explain what I'm doing wrong with a query calculation. As shown on the attached screen print, I entered an expression of "[TotalRates]/[CountRefs]" which uses the names of the two aggregates in the overall footer. However it gives a "does not exist" error.
 
Status
Not open for further replies.

Similar threads

tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
182
tushargaurav
tushargaurav
deborahyr63
  • Locked
  • Question
how to code for service year milestones in 2020
Replies
0
Views
151
deborahyr63
deborahyr63
wwconslt
  • Locked
  • Question
Wild Card for Nine Digit Zip Codes in Prompt
Replies
0
Views
158
wwconslt
wwconslt
Goutham3835
  • Locked
  • Question
Dateset in Cognos framework
Replies
0
Views
155
Goutham3835
Goutham3835
sreevp2020
  • Locked
  • Question
dynamic deafult date in date prompt calandar
Replies
0
Views
166
sreevp2020
sreevp2020

Part and Inventory Search

Sponsor

Back
Top