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!

Search results for query: *

  1. k2msl200

    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...
  2. k2msl200

    IF statement using an operator that evaluates against a list

    I was able to work out the solution to my issue. Had to tinker around with it a bit for it to work. If([Phr NPI]IN('1699857490', '1073861118', '1881961662', '1770648933', '1467471490', '1134372881', '1922035856', '1316205537', '1740275973')) THEN ('PREFERRED') ELSE ('NON-PREFERRED')
  3. k2msl200

    IF statement using an operator that evaluates against a list

    Sorry. I am working with Business Insight Advanced 10.1. What I am trying to accompolish is to create a custom measure that will return "Preferred" for these location ID's '1699857490', '1073861118', '1881961662', '1770648933', '1467471490', and "Non-Preferred" for all others I tried using...
  4. k2msl200

    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...
  5. k2msl200

    IF AND STATEMENT

    Thank you for your help on this, Ties!!! It worked perfectly!!
  6. k2msl200

    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...

Part and Inventory Search

Back
Top