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'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…
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
