nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Hi Everyone, I am reaching out to the community for some help with a formula.

dangelo

I am looking for a way to automate the Batch Index column with a formula. Any help or advice would be greatly appreciated! Thank you!

Accepted answers

rob_marshall

@dangelo

Try using the Rank formula where the 5th parameter is the item of the Incentive Fees/Unrealized Investment Gain list.

All comments

rob_marshall

@dangelo

Try using the Rank formula where the 5th parameter is the item of the Incentive Fees/Unrealized Investment Gain list.

dangelo

Hi Rob, Thank you for the feedback. This was the result I got. Any feedback for how I can make this right? Thanks @rob_marshall

rob_marshall

@dangelo

I thought that is what you wanted. What exactly are you needing the final result to be?

dangelo

Hi Rob, My apologies. I had the incorrect pivot. That formula was just what I needed. Thank you! @rob_marshall

Quick Links

Can you help?

Unanswered questions

Near-Real-Time Anaplan → Claude MCP: Any Faster Than Bulk Export + MySQL?
We're looking to feed live or near-live Anaplan data into Claude through MCP, but our current approach — exporting CSV files via the Anaplan Bulk Export API, loading them into MySQL, and querying from there — has a significant lag (hour-long turnaround). Curious if anyone has found a faster path, whether that's through the…
Anaplan AI Actions
The July and August releases added several useful capabilities to Anaplan AI, including the ability to create and retrieve saved views and create list import actions. It would be valuable to extend these capabilities to support the full end-to-end user story: creating a saved view and using it as the source for an import…
Anaplan Analyst performance on large, sparse models
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.