
Contributor II
2020-05-07
04:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Rank and measures in percentage greater than 100 %
Dear Community,
I have a question about the Rank function.
I've created one table with
-dimension Product,
-the first measure is sum(MC)/sum(TS),
-the second measure is RANK(sum(MC)/sum(TS),4,1)
The problem is that I have a percentage greater than 100 %.
Can someone give me some advice on how to proceed?
Also, I have a lot of filters, which should affect this table and the results in the table.
Thank you in advance!
- Tags:
- rank
726 Views
0 Replies
