Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I would like to display the rank of a company according to sum(Amounts) within a text object. Does anyone know what the expression within the text object would look like?
I thought it might be something like:
=Rank({<[Company]={'ABC'}>}Sum(Amounts))
But that returned an error. Help please!
Hey Manish,
I think he want the Rank to change on other selection, except the Supplier. So I think that the formula that would work for him would be:
=Max({<Company ={'ABC'}>}Aggr(Rank(TOTAL SUM({<Company =>}Amounts),4),Company)) (without the 1)
Best,
S
Hi Andrew,
Try something like this:
Rank(Aggr(Sum(Amount),Company))
When you select any company it will display the rank.
Regards
KC
Jyothish,
Thank you for your response. However, I am trying to display the rank of one particular company at all times, that would update based on other selections. I.e., rank of company A.
Hi,
Try this:
=Rank(sum({<[Company]={'ABC'}>}Amounts))
Regards
KC
This is a kind of work around, but it seems to work. Hopefully you will find this useful.
Try this:
=Concat({State2}Aggr(Rank(Sum({<Company= >}Amount)), Company), '|')
Where State2 would be your name for the alternate state you need in your application. and you will need to lock down the selection of your Company in the alternate state's list box.
Hope this helps
Best,
S
The problem with this method is that it always returns '1' for Company A, regardless of selection
Is there no easier way to do this in a text object than use alternate states? I basically want to instruct it,
"Show Value for 'Company A' in Aggr(Rank(Sum(Amounts)))"
I am sure there must be an easier way to do it, but unfortunately I am not aware of it. I guess somebody else may chip in and give you a better answer. Sorry for not being very helpful.
Best,
S
Thank you sunindia, your answer was helpful - I think it will work, but I will try to find a solution that does not involve alternate states first.
Sure thing Andrew.
Hope you succeed in your quest.
Best,
S