COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: PRIT AMRIT on 08 Aug 2014 06:30:12 AM

Title: Conditional changing measure value
Post by: PRIT AMRIT on 08 Aug 2014 06:30:12 AM
I have a requirement and need your input.

As you could see the attached report print screen, I have a cross tab report with 4 dimensions & 1 measure. This report is based on relational package.
Requirement:


Could you please let me know if you have any logic in mind?

Thank you!

Regards,
Prit
Title: Re: Conditional changing measure value
Post by: Lynn on 08 Aug 2014 07:14:46 AM
Your sample appears to be showing actual information about your employer/client -- I suggest you remove it from your post asap. Even if the numbers are not real it is not appropriate to share how a company approaches their analysis.

You can scratch out the actual product and customer names and replace them with generic labels so as to mask the specifics while still asking your question.
Title: Re: Conditional changing measure value
Post by: bdbits on 08 Aug 2014 04:31:38 PM
Is this not a simple if/then/else or perhaps a case statement in the expression editor?
Or am I missing something?
Title: Re: Conditional changing measure value
Post by: PRIT AMRIT on 09 Aug 2014 11:13:39 PM
QuoteIs this not a simple if/then/else or perhaps a case statement in the expression editor?
Or am I missing something?

Indeed it should do but haven't got it right yet...  :D

@ Lynn -- Thanks for your suggestion. I agree though the values are not real.

Cheers,
Prit