Hi,
Please help understand why my rank function is not working when using descending as my direction.
Please find attached screenshot. I am expecting to do the ranking by starting to highest rank to rank 1.
Thanks in advance for helping.
Tom
Hi Tom,What is the expected behavior when the values to be ranked are all equal to each other like Code3 in your screenshot?
Hi @anirudh, I am planning to filter 1 if this will be successful to get the last occurrence value in code3.
The descending element impacts how larger and smaller numbers are ranked but it is the sequential element of your function impacting the behaviour you mention. Are you always looking to show the final occurrence or just a unique list? If it is the unique option you could try the ISFIRSTOCCURRENCE function, check out the Anapedia page here: https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/ISFIRSTOCCURRENCE.htm
@tompatrick.ting
How about having another module by Code3 (need to create it as a list) where you summarize the number of counts for each Code3 (group), and use that to compare with the Rank result. You can then use this as filter:
- when Rank is equal to the group count or
- transformed Rank i.e initial Rank - group count + 1. In this case, you always use 1 as filter
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
