Forum Discussion
Formula Help
I have used a RANKX formula on a column named Clothes and now I want the top third of the data to get assigned a value of 15, the middle third of the data to be assigned 10, and the bottom third to b...
Perhaps:
Column = VAR __break = MAX([Rank])/3 RETURN SWITCH(TRUE(), [Rank] <= __break,15, [Rank] > 2*__break,5, 10 )
Perhaps:
Column =
VAR __break = MAX([Rank])/3
RETURN
SWITCH(TRUE(),
[Rank] <= __break,15,
[Rank] > 2*__break,5,
10
)