How to use "%CT" in Query Designer

[Former Member]

Hello everyone,

i read that to calculate "Percentage Share of Result" in Query Designer we can use "%CT operator".

But in my Query Designer (Version 7.10, SP10, Patch1) only "%" and "%A" are available to use. There ist no operator named "%CT".

Can someone tell me how to use this operator?

Thanks a lot and best regards,

Susanne

[Former Member]

Hi,

You can find %CT operator in QD under change formula :

Operators => Percentage functions => Percentage share of result

Percentage share of result is %CT

Regards,

Amit

[Former Member]

Hi,

thanks for your answer.

But there is no Percentage share of result under "Operators => Percentage functions".

What I can find under "Operators => Percentage functions" are only % and %A.

Do you have any other ideas?

Thanks again,

Susanne

[Former Member]

Hi,

In the % Functions in a Formula you can find %, %A, %CT, %GT, %RT all 5 of them .

My BW system is at Following Upgrade level:

Software Component    Release    Level    Highest Support 
SAP_BW                701       0007            SAPKW70107

If at a lower upgrade level, you need to upgrade till Specified BW Release to view these Fxn.

You can check yours at System (Top of the window) --> Status . Click the Icon of magnifying glass named Componenet Info to view yours.

Regards

Raj Rai

[Former Member]

Hello Raj Rai,

thank you for your answer.

I have already updated my release to:

BI AddOn 7.x (Based on 7,20), SP 4, Patch 2.

But it still doesn't work!!!

It drives me crazy!!!!

Who can help me!!!

Should I still update my BW??

Thanks again,

Susanne

[Former Member]

Hi everyone,

sorry, i made a mistake...

Everything is ok now.

Thanks to everyone who helped me.

Regards,

Susanne

[former_member182470]

Hello,

Check in "Operators" section in Query designer under "Percentage Functions".

If do not find, then you may have to upgrade to the concerned patch.

Regards,

Suman