Calculated field in Cognos Report Studio

Asked Apr 29 '14 at 13:53

Active Apr 29 '14 at 13:53

Viewed 1,146 times

I am creating reports on Cognos Studio and trying to add a calculated field named Record. Following are the conditions used to create this calculated field:

Dataitem: Record:

IF (com = ‘MASTERLINE’ THEN (com + ‘ ‘ + ML) ELSE (com + ‘ ‘ + ML1)

Dataitem: com

IF Acct_Prod = ‘MLAC’ THEN ‘MASTERLINE’ ELSE (IF Proc_type = ‘00’ THEN ‘LOAN’ ELSE ‘LINE’)

Dataitem: ML

IF Line_Num = ‘00’ THEN ‘’ ELSE Line_Num

Dataitem: ML1

IF Line_num =’00’ THEN ‘’ ELSE ‘Tied to ML’

I am looknig for a combined if statement instead of creating extra data items. Can anyone guide?

asked Apr 29 '14 at 13:53

Excited_to_learn

What prevents you from simply replacing all terms by their definitions? Do you get a run time error? – Marcus Rickert Apr 29 '14 at 22:06
It just makes it a complex query. Anyways, thanks for your response... – Excited_to_learn Apr 30 '14 at 14:50
It may be complex to read afterwards but it won't be computationally complex, at least not more complex than it's components. – Marcus Rickert Apr 30 '14 at 21:50
ok. Thank you for your valuable input – Excited_to_learn Apr 30 '14 at 21:52

Calculated field in Cognos Report Studio

0 Answers0