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:
Hi Community, It appears that values shown here for Q1 are assuming 29 days in Feb 25, when there are actually only 28. My values tie out for all Quarter values and all months shown from Apr 25 forward, and it's not possible for only a single quarter/finite range of months to differ with formula-driven values: Please…
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…
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.…
