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:
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.β¦
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the nodeβ¦
I want to create an S3 connection that will have monthly data stored in individual csv files that is connected to ADO. Around month end, data will be uploaded multiple times, replacing existing csvs. When this happens I want to replace the existing data for that month with the new file. I don't want to have to create aβ¦