Congnos Ranking lowest as Rank 1
0
I am having hard time to rank lowest average number as rank 1, currently it ranking highest average number as rank 1. My current formula see below,
rank([Total Average], [Store Number])
I want it like below picture. How should I do that? Any help will be really appreciate. Thank you
cognos cognos-10 cognos-bi cognos-8 ranking-functions
asked Nov 13 '18 at 22:09
PrasadDPrasadD
257
|
show 1 more comment
0
I am having hard time to rank lowest average number as rank 1, currently it ranking highest average number as rank 1. My current formula see below,
rank([Total Average], [Store Number])
I want it like below picture. How should I do that? Any help will be really appreciate. Thank you
cognos cognos-10 cognos-bi cognos-8 ranking-functions
asked Nov 13 '18 at 22:09
PrasadDPrasadD
257
1
I'm sure you tried this but let just to be sure. Did you try adding ASC to the function?
– Aquatically Challenged Fish
Nov 14 '18 at 17:50
1
rank([Total Average], [Store Number] DESC). Note that the store number will effectively break any ties.
– Johnsonium
Nov 14 '18 at 19:11
@Johnsonium, I did thisrank([Total Average], [Store Number] DESC)Does not do anything. I wonder why is that.
– PrasadD
Nov 15 '18 at 18:13
1
I'm not sure. I created a sample report to make sure I was correct before commenting and it worked for me.
– Johnsonium
Nov 15 '18 at 18:31
@Johnsonium, you are correct your one work, but I figure it out why my one is not working. My total average is a query calculations (( [Post Paid Voice Gross Adds Rank LY] + [Prepaid Actual Rank LY] + [Accessory GP Rank LY] + [DTV Now Rank LY] + [Premium Video Rank LY] + [IPBB Rank LY] + [WTR Rank LY] + [IRPO Rank LY] )/8). When I removed /8 it works fine. I am not sure why is that tho. Anyway Thank you so much for the help.
– PrasadD
Nov 16 '18 at 0:29
|
show 1 more comment
0
0
0
I am having hard time to rank lowest average number as rank 1, currently it ranking highest average number as rank 1. My current formula see below,
rank([Total Average], [Store Number])
I want it like below picture. How should I do that? Any help will be really appreciate. Thank you
cognos cognos-10 cognos-bi cognos-8 ranking-functions
asked Nov 13 '18 at 22:09
PrasadDPrasadD
257
I am having hard time to rank lowest average number as rank 1, currently it ranking highest average number as rank 1. My current formula see below,
rank([Total Average], [Store Number])
I want it like below picture. How should I do that? Any help will be really appreciate. Thank you
cognos cognos-10 cognos-bi cognos-8 ranking-functions
cognos cognos-10 cognos-bi cognos-8 ranking-functions
asked Nov 13 '18 at 22:09
PrasadDPrasadD
257
asked Nov 13 '18 at 22:09
PrasadDPrasadD
257
asked Nov 13 '18 at 22:09
PrasadDPrasadD
257
asked Nov 13 '18 at 22:09
PrasadDPrasadD
257
asked Nov 13 '18 at 22:09
PrasadDPrasadD
257
257
1
I'm sure you tried this but let just to be sure. Did you try adding ASC to the function?
– Aquatically Challenged Fish
Nov 14 '18 at 17:50
1
rank([Total Average], [Store Number] DESC). Note that the store number will effectively break any ties.
– Johnsonium
Nov 14 '18 at 19:11
@Johnsonium, I did thisrank([Total Average], [Store Number] DESC)Does not do anything. I wonder why is that.
– PrasadD
Nov 15 '18 at 18:13
1
I'm not sure. I created a sample report to make sure I was correct before commenting and it worked for me.
– Johnsonium
Nov 15 '18 at 18:31
@Johnsonium, you are correct your one work, but I figure it out why my one is not working. My total average is a query calculations (( [Post Paid Voice Gross Adds Rank LY] + [Prepaid Actual Rank LY] + [Accessory GP Rank LY] + [DTV Now Rank LY] + [Premium Video Rank LY] + [IPBB Rank LY] + [WTR Rank LY] + [IRPO Rank LY] )/8). When I removed /8 it works fine. I am not sure why is that tho. Anyway Thank you so much for the help.
– PrasadD
Nov 16 '18 at 0:29
|
show 1 more comment
1
I'm sure you tried this but let just to be sure. Did you try adding ASC to the function?
– Aquatically Challenged Fish
Nov 14 '18 at 17:50
1
rank([Total Average], [Store Number] DESC). Note that the store number will effectively break any ties.
– Johnsonium
Nov 14 '18 at 19:11
@Johnsonium, I did thisrank([Total Average], [Store Number] DESC)Does not do anything. I wonder why is that.
– PrasadD
Nov 15 '18 at 18:13
1
I'm not sure. I created a sample report to make sure I was correct before commenting and it worked for me.
– Johnsonium
Nov 15 '18 at 18:31
@Johnsonium, you are correct your one work, but I figure it out why my one is not working. My total average is a query calculations (( [Post Paid Voice Gross Adds Rank LY] + [Prepaid Actual Rank LY] + [Accessory GP Rank LY] + [DTV Now Rank LY] + [Premium Video Rank LY] + [IPBB Rank LY] + [WTR Rank LY] + [IRPO Rank LY] )/8). When I removed /8 it works fine. I am not sure why is that tho. Anyway Thank you so much for the help.
– PrasadD
Nov 16 '18 at 0:29
1
1
I'm sure you tried this but let just to be sure. Did you try adding ASC to the function?
– Aquatically Challenged Fish
Nov 14 '18 at 17:50
I'm sure you tried this but let just to be sure. Did you try adding ASC to the function?
– Aquatically Challenged Fish
Nov 14 '18 at 17:50
1
1
rank([Total Average], [Store Number] DESC). Note that the store number will effectively break any ties.
– Johnsonium
Nov 14 '18 at 19:11
rank([Total Average], [Store Number] DESC). Note that the store number will effectively break any ties.
– Johnsonium
Nov 14 '18 at 19:11
@Johnsonium, I did this
rank([Total Average], [Store Number] DESC) Does not do anything. I wonder why is that.– PrasadD
Nov 15 '18 at 18:13
@Johnsonium, I did this
rank([Total Average], [Store Number] DESC) Does not do anything. I wonder why is that.– PrasadD
Nov 15 '18 at 18:13
1
1
I'm not sure. I created a sample report to make sure I was correct before commenting and it worked for me.
– Johnsonium
Nov 15 '18 at 18:31
I'm not sure. I created a sample report to make sure I was correct before commenting and it worked for me.
– Johnsonium
Nov 15 '18 at 18:31
@Johnsonium, you are correct your one work, but I figure it out why my one is not working. My total average is a query calculations (
( [Post Paid Voice Gross Adds Rank LY] + [Prepaid Actual Rank LY] + [Accessory GP Rank LY] + [DTV Now Rank LY] + [Premium Video Rank LY] + [IPBB Rank LY] + [WTR Rank LY] + [IRPO Rank LY] )/8). When I removed /8 it works fine. I am not sure why is that tho. Anyway Thank you so much for the help.– PrasadD
Nov 16 '18 at 0:29
@Johnsonium, you are correct your one work, but I figure it out why my one is not working. My total average is a query calculations (
( [Post Paid Voice Gross Adds Rank LY] + [Prepaid Actual Rank LY] + [Accessory GP Rank LY] + [DTV Now Rank LY] + [Premium Video Rank LY] + [IPBB Rank LY] + [WTR Rank LY] + [IRPO Rank LY] )/8). When I removed /8 it works fine. I am not sure why is that tho. Anyway Thank you so much for the help.– PrasadD
Nov 16 '18 at 0:29
|
show 1 more comment
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53290251%2fcongnos-ranking-lowest-as-rank-1%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53290251%2fcongnos-ranking-lowest-as-rank-1%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
I'm sure you tried this but let just to be sure. Did you try adding ASC to the function?
– Aquatically Challenged Fish
Nov 14 '18 at 17:50
1
rank([Total Average], [Store Number] DESC). Note that the store number will effectively break any ties.
– Johnsonium
Nov 14 '18 at 19:11
@Johnsonium, I did this
rank([Total Average], [Store Number] DESC)Does not do anything. I wonder why is that.– PrasadD
Nov 15 '18 at 18:13
1
I'm not sure. I created a sample report to make sure I was correct before commenting and it worked for me.
– Johnsonium
Nov 15 '18 at 18:31
@Johnsonium, you are correct your one work, but I figure it out why my one is not working. My total average is a query calculations (
( [Post Paid Voice Gross Adds Rank LY] + [Prepaid Actual Rank LY] + [Accessory GP Rank LY] + [DTV Now Rank LY] + [Premium Video Rank LY] + [IPBB Rank LY] + [WTR Rank LY] + [IRPO Rank LY] )/8). When I removed /8 it works fine. I am not sure why is that tho. Anyway Thank you so much for the help.– PrasadD
Nov 16 '18 at 0:29