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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Cognos 10 - Custom Field Development - WHERE?
I am trying to create a custom calculation/field in COGNOS 10 Workspace Advanced that can identify the total units for my specialty products based on a specialty indicator ('Y'). Specialty Ind is a dimension that includes 'Y' and 'N'. Total Units is a number/metric With my previous reporting...- k2msl200
- Thread
- Replies: 1
- Forum: Cognos solutions
-
IF statement using an operator that evaluates against a list
Cognos Experts, I need a little help with an expression. This Expression works, IF ([Phr NPI] ='1073861118') THEN ('PREFERRED") ELSE ('PREFERRED), but instead of using ='1073861118', I need it to evaluate against a list of Phr NPI's rather than equaling just one. Basically I need something...- k2msl200
- Thread
- Replies: 4
- Forum: Cognos solutions
-
IF AND STATEMENT
I'm new to working in COGNOS. The version I work in is the Business Insite advanced v10.1.1. I have previous knowledge writing expressions in business objects DSS 1.5, MicroStrategy and MS Excel, but I'll be damned if I cant figure out how to create what I need using the Data Item Expression...- k2msl200
- Thread
- Replies: 2
- Forum: Cognos solutions
