Rank on various column() in table

stha142020 — Mon, 02 Jan 2023 11:46:45 GMT

I am trying to calculate a total rank based on several sub ranks.
The sub ranks are calculated with the following expression: Aggr(Rank(Sum()),[Store number])
But this does not work on the Rank total where I have tried the following expression:
aggr(rank(1000
-
((column(3)* 0.5) +
(column(5)* 0.2) +
(column(7)* 0.1) +
(column(9)* 0.1) +
(column(11)* 0.1))),[Store number])

No.	Store	Rank total	Rank 1	Rank 2	Rank 3	Rank 4	Rank 5	Rank sum
2	Store 2	-	2	9	15	7	9	994
4	Store 4	-	4	3	6	52	85	983
3	Store 3	-	3	5	10	56	98	981
7	Store 7	-	7	48	24	22	13	981
6	Store 6	-	6	36	27	48	17	981
1	Store 1	-	1	87	28	19	12	976
16	Store 16	-	16	7	20	72	64	975
18	Store 18	-	18	17	22	77	95	968
11	Store 11	-	11	76	53	68	28	964
17	Store 17	-	17	53	44	116	20	963
8	Store 8	-	8	32	42	117	127	961
12	Store 12	-	12	101	122	6	54	956
14	Store 14	-	14	102	87	36	73	953
9	Store 9	-	9	82	95	53	127	952
5	Store 5	-	5	121	121	31	75	951
19	Store 19	-	19	54	78	94	129	950
13	Store 13	-	13	106	80	23	127	949
10	Store 10	-	10	119	91	21	127	947
15	Store 15	-	15	69	97	106	127	946

Any suggestions?

Re: Rank on various column() in table

vinieme12 — Tue, 03 Jan 2023 07:14:24 GMT

can you post a sample app?

topic Rank on various column() in table in App Development

Rank on various column() in table

Re: Rank on various column() in table