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 in COGNOS.
Here is what I'm ultimately trying to accompolish:
Pharmacy Type (Attribute)
Days Supply (Metric)
=IF(AND([Pharmacy Type]="Retail",[Days Supply]>=84),"Retail 90",IF(AND([Pharmacy Type]="Retail",[Days Supply]<84),"Retail 30",IF(AND([Pharmacy Type]="Mail Order",[Days Supply]>0),"Mail","UNKNOWN")))
Any assistence is appreciated.
Here is what I'm ultimately trying to accompolish:
Pharmacy Type (Attribute)
Days Supply (Metric)
=IF(AND([Pharmacy Type]="Retail",[Days Supply]>=84),"Retail 90",IF(AND([Pharmacy Type]="Retail",[Days Supply]<84),"Retail 30",IF(AND([Pharmacy Type]="Mail Order",[Days Supply]>0),"Mail","UNKNOWN")))
Any assistence is appreciated.