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!

Calc Coln in Impromptu

Status
Not open for further replies.
prince18

prince18

Technical User
Mar 27, 2006
15
0
0
US
Hi Frnds,
I am working on Impromptu 7.3 where I need to work with a crosstab report. In the crosstab, I have date column in the side and 3 other columns in the column side. From those 3 columns I had a calculated column inserted into the report. What my question is, I need to filter the data coming into the report based on that calculated column. Suppose if the calculated column contains 0 and non 0 values, How can I specify a condition to get data into the report where the calc column values are 0s??

Hope this gives an understanding of my problem.

Thanks in advance
P
 
Status
Not open for further replies.

Similar threads

beegeeblueboy
  • Locked
  • Question
cdate function Impromptu 7.5 SQL script not recognised by SQL Server
Replies
0
Views
82
beegeeblueboy
beegeeblueboy
tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
72
tushargaurav
tushargaurav
deborahyr63
  • Locked
  • Question
how to code for service year milestones in 2020
Replies
0
Views
57
deborahyr63
deborahyr63
wwconslt
  • Locked
  • Question
Wild Card for Nine Digit Zip Codes in Prompt
Replies
0
Views
51
wwconslt
wwconslt
Goutham3835
  • Locked
  • Question
Dateset in Cognos framework
Replies
0
Views
54
Goutham3835
Goutham3835

Part and Inventory Search

Sponsor

Back
Top