Can somebody help me if a boolean is true for a particular month and if we need to make the boolean true for all the months coming in future how can be do that?
Also, after few months if I want to make that boolean false, how can we do that?
@CommunityMember11
Create another line item and use the function Previous(line item with the boolen)
Hi @rob_marshall - Thanks for helping but my scenario is different.
Screenshot below:
I want if Input is true in Jan 24 and false in Feb 24, my final value line item should be true for all the months from Feb 24 onwards because Jan 24 is true.
Also, suppose I want to make it false after sept 24, how can I do that?
Try this
@rob_marshall - how about reseting it after 5-6 months?
Ok, then try this
Better yet, for the previous line item, simply use this formula
Set the boolean to true in your logic for the current and future months. To make it false later, update the condition to false when needed.
true
false
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a…
Hi I'm looking to speak to people who have used/are using the Docusign integration in their business. We are exploring the possibility, but we find the current setup quite limiting in terms of how an end user would interact with the integration, but also issues with concurrency and number field formats. Would appreciate…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
