When the user select Two Boolean Check the range is defined so I want to get the range of values respective months.
Hello
This is an example. How do you like it?
Cumulate = Previous(Cumulate) + CHK Count Taichi
I hope this helps
What's the Formula for Count Cumulate?
But I want the Range only when two booleans are selected! @Amaya the count cumulate is getting values when one boolean is selected which is the factor that is driving Between? Boolean.
Hi You may need Two Line items specifying From and To months boolean selection, and then using previous and next functions in intermediate line items you can arrive at final line item filter upon which you can fetch the required values saying IF Final then Amount else 0. Additionally you can use system module to drive From and To selections using Time dropdown(Date) and tweaking From and To logic like START() = 'SYS07 Include Sleection'.Start Date Module View:
Blueprint View:
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…
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.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
