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

Unable to use the two measures( one with aggregate) and the other with

Status
Not open for further replies.
Anu1284

Anu1284

Programmer
Sep 24, 2003
25
0
0
US
I have created a measure without aggregate
1. Days (Database field / 5)
and another measure with aggregate
2. PTO Hours (sum (Database field)).
When the measure with aggregate field alone is used in the report, it works well.
When the measure with aggregate is used with the measure without aggregate, it throws an error as "Your database does not allow you to do aggregates with the Days object".

Please let me know how to handle this situation.
 
Sort by date Sort by votes
What database are you using?

You really need to aggregate ALL your measures. Can't you do sum(Database field/5)

Some databases don't allow calculations in the group by clause.

Steve Krandel
Westbay Solutions
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JOEYB99
  • Locked
  • Question
Problem with Webi Hyperlink to SAP t-code CATS_DA
Replies
0
Views
79
JOEYB99
JOEYB99
Clappy2000
  • Locked
  • Question
Date Prompt in Freehand SQL excluding the Time (Web Rich Client Report)
Replies
0
Views
102
Clappy2000
Clappy2000
Emmy2368
  • Locked
  • Question
Creating Year to Date Filter
Replies
4
Views
95
Emmy2368
Emmy2368
lahddah
  • Locked
  • Question
Header and Details showing horizontally
Replies
7
Views
104
SkipVought
S
PWD
  • Locked
  • Question
Copy As Text Produces All The Columns + 1
Replies
2
Views
40
PWD
PWD

Part and Inventory Search

Sponsor

Back
Top