I have a module with three line items: "From", "To" and "Any", which are all Boolean formatted. I also have time as a dimension. "From" is just true for one month, which comes from another module, and the same goes for "To".
My problem is within the "Any". I want that to be true for all dates between the "From" and "To". For example, if "From" is Jan 20, and "To" is Oct 20, I want all month between Jan and Oct to be true.
From? Cumulate = From? OR PREVIOUS(From? Cumulate)
To? Cumulate = To? OR PREVIOUS(To? Cumulate)
Any? = From? Cumulate AND To? OR NOT To? Cumulate
Caveat is you do need to ensure From? and To? are populated. It assumes if no To?, then it is included but you could add in a condition to check if there was no value for To? for the year to stop that if needed