If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Chart with variable baseline

Started by mtenklooster, 25 Feb 2016 06:59:00 AM

Previous topic - Next topic

mtenklooster

Hoi,

I am trying to make baseline with a query calculation.

The baseline must be for all organisations code 90% except for Cardiologie, then it must be 50%.
I made a data-item in the query:

IF(
CAPTION( [DAS_KPI_].[Alle Organisatie_Codes].[Alle Organisatie_Codes].[Organisatie_Code]) = '[Cardiologie]'  )
THEN (0.5)
ELSE (0.9)

And by numeric baselines, I 'picked up"this data-item.
But the baseline sticks on 90%, what am I doing wrong?  :(

I hope someone can help me
Kind regards,
Marianne