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